Moving msdb and changing local connection

• SW_Lindsay

  SSCommitted

  Points: 1983

  More actions

  November 6, 2007 at 9:11 am

  #120947

  I have moved msdb from one server to another. But when I do the 2005 Maintenance plans I have built have a local connection pointing to the old server. How do I update this to the new server without recreating all the Maintenance Plans?

  Steve

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  November 6, 2007 at 9:53 am

  #748753

  This post might help -

  http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=389519&SiteID=1&mode=1

  Tommy

  Follow @sqlscribe