Post reply

Restore system databases from 2005 to 2008

  • November 2, 2012 at 6:25 am

    #284145

    could we restore sql server 2005 system datbases into sql server 2008 ?

  • November 2, 2012 at 6:44 am

    #1555439

    If the upgrade is in place, it will upgrade the databases for you, but if it is side by side then no, as with each release of the product the databases change and due to you restoring the db from 2005 it wont run the upgrade scripts on the DB to make it a 2008 db.

    You will need to script logins, linked servers, jobs etc.

  • November 2, 2012 at 9:43 am

    #1555559

    No, just to be clear.

    You cannot restore system databases (master, model, msdb) from earlier versions to newer ones. As Anthony mentioned, you need to script things out and run the scripts on the newer version.

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

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