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?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
sp_dbcmptlevel dbname, 90
Showing posts with label loading. Show all posts
Showing posts with label loading. Show all posts
Saturday, February 25, 2012
Subscribe to:
Posts (Atom)