Script Maintenance Plans SQL Server 2005

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  January 20, 2012 at 7:27 am

  #255213

  What is the easiest way to script out the maintenance plans so that I can deploy them to a new server?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• padhis

  SSCommitted

  Points: 1762

  More actions

  January 20, 2012 at 7:39 am

  #1436491

  Check this.

  http://sqlservernewbie.blogspot.com/2008/10/how-to-importexport-sql-server.html

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  January 20, 2012 at 7:43 am

  #1436500

  padhis (1/20/2012)

  ---

  Check this.

  http://sqlservernewbie.blogspot.com/2008/10/how-to-importexport-sql-server.html

  Nice but it hangs when I load the page.

  Thanks.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/