Database File Location

Copy Database Wizard

Copy Database Wizard Help

Database File Location

Use this screen to get an overview of the status for all the data and log files to be copied or moved. Files that are ready to be moved or copied have a checkmark in the Status field. If a name conflict or disk space problem exists, a red X appears in the Status field.

If there are disk space problems or naming conflicts, click either Modify or Next to open the Database Files Dialog Box, where you can resolve name conflicts and space problems.

Files

Displays the data files and log files that are included.

Destination drives

Displays the drive name of the destination server for the data files and log files. This information is set automatically using data from the registry of the destination server.

Size

Displays the size of the data or log file.

Status

Displays a green checkmark if the file is ready to be moved or copied.

Displays a red X if disk space problems or naming conflicts exist.

Modify

Click to open the Database File dialog box. Use this dialog box to resolve naming conflicts and/or to specify alternative drives if disk space problems exist.

Refresh

Clicked to reevaluate disk space and naming conflicts. Updates appear in the Destination drives and Status fields.

Note  In Microsoft® SQL Server™ 2000, the Size field is not updated, even if the size of the files has changed. For example, updates could have been made to the list of databases selected.