Completing the Copy Database Wizard
This screen provides an overview of the selections you have made, including:
- Databases selected and whether these will be moved or copied.
- File locations for each database.
- Logins to be included.
- Any selected objects from the master database.
- Any selected jobs from the msdb database.
Important When using the Copy Database Wizard to upgrade databases from Microsoft® SQL Server™ version 7.0 to SQL Server 2000, the administrator should run sp_updatestats (update statistics) against the database on the destination server. This is important for optimum performance of the copied database.
Back
Click Back to review or change your selections.
Finish
Click Finish to run the move or copy operation and view its progress in the Log Detail screen.