Post reply

Restoring MSDB on different ver of SQLServer

  • October 17, 2005 at 8:17 am

    #165662

    Hi ,

    Is there any way I can restore MSDB database of old SQL Server (2000 and version 134217922 ) on the new SQL Server (2000 version version 134218488) . I am not able to restore because , both Server are of different version .

    Thanks

    Shailu

    DBA

  • October 18, 2005 at 6:27 am

    #597905

    Once in a bind I did a restore that appeared to work. 

    I think the process I used was:

    I restored a MSDB database to another name - "MSDB_OldV" on the target server.  Then backed it up.  Then restored it again but as MSDB.  Then reapplied service pack to have scripts that upgrade MSDB run against the DB.

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

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