Completing the Copy Database Wizard

Copy Database Wizard

Copy Database Wizard Help

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.


Click Back to review or change your selections.


Click Finish to run the move or copy operation and view its progress in the Log Detail screen.

See Also