Script database maintenance plan

• WhiteLotus

  SSChampion

  Points: 12122

  More actions

  October 1, 2019 at 3:16 am

  #3684810

  Hi

  I would like to script the maintenance plan that has been created and copy it to other servers

  I don't want create it manually in every server as it consumes a lot of time

  How do I achieve this ?

  Please kindly share your feedback

  Thanks heap

• Michael L John

  One Orange Chip

  Points: 27065

  More actions

  October 1, 2019 at 6:32 pm

  #3685089

  A google search turned this up:

  https://www.mssqltips.com/sqlservertip/5335/move-sql-server-maintenance-plan-from-one-server-to-another/

  How many servers do you have?

   

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/