Share via

  • Article

Copy Database Wizard (Configure Destination Database)

Allows you to change the database name and to specify the location and names of the database files. This page appears once for each database being moved or copied.

Options

  • Source database
    Displays the name of the database being moved or copied. This box is read-only.

  • Destination database
    Enter the name of the database that is being created or the name of the database after it is moved.

  • Filename
    Specify the names of the files as they appear on the source server.

  • Size (MB)
    Displays the size of the file in megabytes.

  • Destination folder
    Specify the proposed destination location.

  • Status
    Displays "OK" if the file can be created, or provides a reason if the file cannot be created.

  • Refresh
    Refresh the list of databases and files.

  • Stop the transfer if a database or file with the same name exists at the destination.
    Cancel the copy or move operation if a database with the same name exists on the destination server.

  • Drop any database on the destination server with the same name, then continue with the database transfer, overwriting existing database files.
    If a database with the same name exists on the destination server, the destination database is dropped, and then the copy or move operation continues.

Note

After you use the Copy Database Wizard to copy a SQL Server 2005 or SQL Server 2000 database to SQL Server 2008, the database becomes available immediately and is then automatically upgraded. If the database has full-text indexes, the upgrade process either imports, resets, or rebuilds them, depending on the setting of the Full-Text Upgrade Option server property. If the upgrade option is set to Import or Rebuild, the full-text indexes will be unavailable during the upgrade. Depending the amount of data being indexed, importing can take several hours, and rebuilding can take up to ten times longer. Note also that when the upgrade option is set to Import, if a full-text catalog is not available, the associated full-text indexes are rebuilt. For information about viewing or changing the setting of the Full-Text Upgrade Option property, see How to: View or Change Server Properties for Full-Text Search (SQL Server Management Studio).