Select the Databases to Move or Copy

Select the Databases to Move or Copy

SQL Server 2000

Use this screen to select the database or databases you want to move or copy from the source server to the destination server. The following databases cannot be moved or copied:

  • Databases that exist on the destination server.

  • System databases.

  • Databases marked for replication.

  • Databases marked Inaccessible, Loading, Offline, Recovering, Suspect, or in Emergency Mode.
Full-Text Catalogs

When you move or copy databases that contain full-text catalogs, full-text functionality is stopped, and then must be manually restored. The Microsoft Search service manages full-text catalogs and runs in the database to provide this service. Full-text search is stopped by the Copy Database Wizard so databases can be placed into single-user mode, a requirement for a move or copy operation.

If you want to copy a database with full-text catalogs, full-text catalogs for the database are unavailable at the source server after the copy operation has been completed. You must manually repopulate full-text catalogs on the destination server.

If you want to move a database with full-text catalogs, none of the associated full-text catalog files are moved when the database is moved. These files must be moved manually by the database administrator.

Options

Move

Select to move the database to the destination server.

Copy

Select to copy the database to the destination server.

Source

Displays the databases that exist on the source server.

Destination

Displays the status of the source database on the destination server:

OK
The source database can be moved or copied.
Already exists
The source database already exists and cannot be copied.
System database
The source database is a system database and cannot be copied, although selected objects from the master and msdb databases can be copied.
Replication database
The souce database is involved in replication, and cannot be copied.
Other
For special cases, the specific status of the souce database will be noted.

Refresh

Refresh the list of databases.

Data & Log file location (Windows 98 servers only)

The list appears when a Microsoft® Windows 98 server has been selected as the source server. Select a location from the list to enable the Next button.

Click Next to verify that all data and log files for the selected databases are available at the selected location.

Next

Start the validation process, and then move to the next screen.

See Also

Upgrading Databases from SQL Server 7.0 (Copy Database Wizard)

Using the Copy Database Wizard

Show:
© 2016 Microsoft