Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
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)

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft