Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    5

    Unanswered: backup of SQL Server 2000 loading to 2005

    I want to restore a backup of a SQL Server 2000 database to SQL Server 2005. Would I need to do anything after running the restore to upgrade the database?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Not really. When the database is restored, it will be in SQL 2000 compatibility mode, so you will not be able to use any of the new bells and whistles. To fix that, you just run
    Code:
    sp_dbcmptlevel dbname, 90

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •