Export (0) Print
Expand All

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.

    ms190775.note(en-US,SQL.90).gifImportant:
    To ensure optimal performance of an upgraded database, run sp_updatestats (update statistics) against the upgraded database on the SQL Server 2005 server.

Community Additions

ADD
Show:
© 2014 Microsoft