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.
Technology Tips and News
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.
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
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...