Post reply

How to restore backup file of sql server 2000 in 2005

  • November 7, 2008 at 10:44 pm

    #201073

    Hi,

    Can anyone tell me that how i can restore a database from sql server 2000 to sql server 2005?

    With regards,

    Sunil

  • November 8, 2008 at 7:12 am

    #895953

    You can use the RESTORE command or the SQL Server Management Studio GUI to restore a 2000 backup to 2005. Once it is restored the compatibility level will be set to 2000 but you can change it to 2005. You should look at Upgrade Advisor before doing it as potential problems will be flagged.

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

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