How to specify a SQL Server maintenance plan subtask to run unconditionally on success or failure of preceding tasks?
I am having a (rather standard) daily maintenance plan created with SQL Server Management Studio Maintenance Plan Wizard. AFAIU, the penultimate task "Back Up Database Task" will be executed ...
How to give the least permissions for CRUD-managing and running SQLServerAgent jobs as well as Maintenance Plans?
Follow up to my question "What's the owner of SqlServerAgent job for?" Basically, I am trying to understand how to create a user-login with least privileges for CRUD-maintaining SQLServerAgent jobs ...
What is the possible use of owner of an SQL Server Agent job, I wonder? Removed, and left it blank and the job still succeeds
Any way to import-export-migrate-save-restore a maintenance plan without having SSIS installed (and running)? [duplicate]
I am having dozens of MSSQL Servers 2012 R2 on Windows Server 2008 R2 with similar setup, configuration (in virtual machines) in production. Neither has SSIS installed. I have to similarly maintain ...
Is there a way to copy maintenance plans from one SQL Server 2012 to another? Both servers are not accessible via the same copy of Management Studio at the same time (on different networks).