Maintenance Plans

Hi,

We are planning to created few maintenance plans (Same Plans) in around 20 SQL Servers.(SQL Server 2012)

What is the easiest way instead of manual process?. I don't want to backup and restore MSDB.

June 21st, 2015 7:33pm

Download MaintenanceSolution.sql. This script creates all the objects and jobs that you need.

 using the SQL Server Maintenance Solution:

https://ola.hallengren.com

use this very us

Free Windows Admin Tool Kit Click here and download it now
June 21st, 2015 8:41pm

 instead of maintenance plans - try ola hallengren maintenance scripts - his scripts are widely known and work very well.

you can download the scripts from here : https://ola.hallengren.com/

if you still want maintanance scripts, you can use script to get the package data and insert into other servers,

something like this 

use [Newserver]
go
insert into msdb.dbo.sysssispackages(name,id,createdate,folderid,ownersid,packagedata,packageformat,vermajor,
verminor,verbuild,verid)
select name,newID(),createdate,folderid,ownersid,[packagedata],packageformat,vermajor,verminor,verbuild,verid 
from [oldserver].msdb.dbo.sysssispackages
where name like 'mydatabaseMaintenancePlan'

and then you can script the maintenance job and create that on each instance...

June 21st, 2015 8:46pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics