Online Documentation for SQL Administrator for SQL Server

Selecting databases

At this step of the wizard you should specify the databases to be detached from the instance of SQL Server.

The grid displays all databases located on the selected server and their states. To select a database to be detached from a server select it in the list and set the respective flag in the Detach column.

Note that you can detach a database only if it has no active connections and it is not enabled for replication. To clear the current connections to the database, select it in the list and set the respective flag in the Disconnect all connections column.

To update the database statistics before detaching the database, select it in the list and set the respective flag in the Update Statistics column.

Click the Next button to proceed to the Detaching database step of the wizard.