Post reply

Copy Maintenance Plans from server to server?

  • December 7, 2011 at 4:06 am

    #247332

    Is there a way to script or copy maintenance plans? I need to setup plans on servers. I need to synchronize my data between 2 server.

    Please guide me, Thanks

    phan mem quan ly toa nha

  • December 7, 2011 at 4:25 am

    #1417942

    extract the ssis package from server1 then upload to server2

    this is assuming that you have the same config, database names etc on server2 which are detailed in the MP's on server1 otherwise quickest way would be to create new MP's on server2

    edit

    in fact, there will be connection strings which could be hardcoded to the SQL server, instead of using . or (local) for the server so you might be best of just creating new MP's from the start.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply