How to upgrade databases online using the Copy Database Wizard (Enterprise Manager)
To upgrade a SQL Server 7.0 database to a SQL Server 2000 database
- Expand a server group, and then expand a server.
- Right-click the server, point to All Tasks, and then click Copy Database Wizard.
- 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.