Post reply

Maintenance Plan Backup

  • July 3, 2012 at 3:41 am

    #392645

    Hi All,

    I have a query, My current server is taking down & making up another server, so i am moving all Databases to new server.

    I want to know, Maintenance Job shall i Export/Backup & in new server Import/Restore. can it is possible ? i am using SQL SERVER 2008...

    Thanks in Advance...

    Satish

  • July 3, 2012 at 4:07 am

    #1508119

    If I understand right, you want to move all users databases from Server1 to Server2?

    There are a number of methods to do the task

    Backup & Restore

    Attach & Detach

    Copy Database Wizard

    Also ensure that any objects in MASTER and MSDB are scripted and can be run on Server2, like logins, jobs, linked servers etc.

    You could impliment something like logshipping and when ready to migrate from Server1 to Server2 issue a role switch, backing up the tail logs of Server1 with NORECOVERY and then restore them on Server2 with RECOVERY.

  • July 3, 2012 at 4:11 am

    #1508124

    Hi Anthony,

    I am not taking about Databases i want to move the maintenance Job's....

  • July 3, 2012 at 4:21 am

    #1508129

    Ah well, I would say recreate them as when you save a maintenance plan, it stores the hostname in the connection string.

    You could export them and import them, but you would need to re-open them and change the server it points at to be the new local machine. So might be quicker to just recreate them.

  • July 3, 2012 at 4:28 am

    #1508135

    Hi Anthony,

    Re-creation is very difficult, the jobs are very big. Even i am not understand that Job also. Can you advice any another alternate way??

  • July 3, 2012 at 4:29 am

    #1508137

    Export, import, then open each MP in the new server and change the connection managers.

    Or

    Export, open each SSIS package in BIDS change the connection managers, import.

Viewing 6 posts - 1 through 5 (of 5 total)

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