Export (0) Print
Expand All
Expand Minimize

How to upgrade databases online using the Copy Database Wizard (Enterprise Manager)

SQL Server 2000

To upgrade a SQL Server 7.0 database to a SQL Server 2000 database

  1. Expand a server group, and then expand a server.

  2. Right-click the server, point to All Tasks, and then click Copy Database Wizard.

  3. Complete the steps in the wizard.

Important  After upgrading databases from SQL Server 7.0, run sp_updatestats (update statistics) against the database on the destination server to ensure optimal performance of the copied database.

See Also

Copy Database Wizard Help

Database Upgrade from SQL Server 7.0 (Copy Database Wizard)

Show:
© 2014 Microsoft