Post reply

SQL Server Upgradation from 2005 to 2008

  • September 16, 2013 at 9:05 am

    #297923

    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

    #1650750

    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