Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Migration of Maintenance Plans - Server to Server Expand / Collapse
Author
Message
Posted Thursday, July 11, 2013 1:58 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 4, 2015 3:54 AM
Points: 185, Visits: 440
Hi All,

I have setup some Maintenance plans over time and now am looking at installing a replacement server.

Is there an easy way to migrate the plans over ( edit after if required )

Thanks


________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP

Please don't trust me, test the solutions I give you before using them.
Post #1472461
Posted Thursday, July 11, 2013 2:40 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 5:36 AM
Points: 708, Visits: 1,200
maintenance plans are stored in msdb.
So restoring the msdb on new server should server your purpose.


Pramod
SQL Server DBA | MCSE SQL Server 2012/2014

in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
Post #1472468
Posted Friday, July 12, 2013 12:17 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 1, 2015 7:33 AM
Points: 379, Visits: 1,101
Check out Ola's Maintenance solution.
Post #1473205
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse