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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment