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: Today @ 8:04 AM
Points: 188, Visits: 448
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


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, August 17, 2015 5:15 AM
Points: 715, Visits: 1,225
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, August 26, 2015 12:12 PM
Points: 380, Visits: 1,119
Check out Ola's Maintenance solution.
Post #1473205
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse