How to: Upgrade to SQL Server 2005 with the Copy Database Wizard
SQL Server 2005
This topic describes how to use the Copy Database Wizard to upgrade a SQL Server 2000 database to a SQL Server 2005 database.
When using the Copy Database Wizard to upgrade a database, adhere to the following requirements:
-
Before upgrading, make sure that no applications or services are trying to access the database. Do not use read-only mode, as this will result in an error.
-
You cannot rename the database during this operation.
-
Connect to any instance of SQL Server Database Engine using Object Explorer in SQL Server Management Studio.
-
Expand Databases, right-click a database, point to Tasks, and then click Copy Database.
-
Complete the steps in the wizard.
Important: To ensure optimal performance of an upgraded database, run sp_updatestats(update statistics) against the upgraded database on the SQL Server 2005 server.
