September 16, 2013 at 9:05 am
Can you please any one clarify my below doubts, because we are going to Upgrade SQL 2005 to 2008
1) Can we attach SQL 2005 DB .mdf file in SQL Server 2008 ?
2) Can we restore SQL 2005 User Databases in SQL 2008 ?
and 3) Can we restore SQL 2005 System Databses (Master,MSDB..etc) into SQL Server 2008 ?
September 17, 2013 at 5:44 am
1) Can we attach SQL 2005 DB .mdf file in SQL Server 2008 ?
Yes, you can
2) Can we restore SQL 2005 User Databases in SQL 2008 ?
Again, no problem, but you need to change the compatibility level manually.
and 3) Can we restore SQL 2005 System Databses (Master,MSDB..etc) into SQL Server 2008 ?
Don't even think about it.
While it's theoratically possible, you will end up in all kind of problems. Script out your Logins, Jobs, Alerts etc. or use SSIS to transfer these to your new machine.
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy