November 2, 2012 at 6:25 am
could we restore sql server 2005 system datbases into sql server 2008 ?
November 2, 2012 at 6:44 am
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
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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply