How to: Upgrade to SQL Server 2005 with the Copy Database Wizard

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.

  1. Connect to any instance of SQL Server Database Engine using Object Explorer in SQL Server Management Studio.

  2. Expand Databases, right-click a database, point to Tasks, and then click Copy Database.

  3. Complete the steps in the wizard.

    To ensure optimal performance of an upgraded database, run sp_updatestats (update statistics) against the upgraded database on the SQL Server 2005 server.