Migration of Maintenance Plans - Server to Server

• SteveEClarke

  SSCertifiable

  Points: 5161

  More actions

  July 11, 2013 at 1:58 am

  #296234

  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.

• psingla

  Hall of Fame

  Points: 3840

  More actions

  July 11, 2013 at 2:40 am

  #1631493

  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/

• ggoble

  Hall of Fame

  Points: 3337

  More actions

  July 12, 2013 at 12:17 pm

  #1632106

  Check out Ola's Maintenance solution.[/url]