Here’s the steps:
-
Make a backup of your database on SQL 2000
-
Then move the backup to the new SQL Server 2005 server
-
Perform a restore in the SQL Server 2005.
-
The database will be up instantly.
-
Set the compatibility level of the new database that is created in SQL 2005 so that it match SQL 2000 before performing the restore process.
PS:
- But remember that You can’t backup database on 2005 and restore it to 2000 since there is no backward compatibility works.
- Do not forget to map the user to the database too.
Tags: sql server 2000, sql server 2005, microsoft, sql server
