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, September 4, 2014 5:03 AM
Points: 177, Visits: 417
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


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

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


Pramod
SQL Server DBA | MCSA SQL Server 2012

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: Yesterday @ 2:24 PM
Points: 378, Visits: 1,020
Check out Ola's Maintenance solution.
Post #1473205
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse