Online Documentation for SQL Manager for SQL server

Selecting the database

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


Use the Database drop-down list to select the database to be detached.

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, use the corresponding Clear connections button.


Press the Refresh button to get the current status of the selected database.


Detach Database - Selecting the database



CheckBox Update statistics before detaching

Check this option to update the database statistics before detaching the database.


CheckBox Unregister database

Using this option you can unregister the database (if it has been registered in SQL Manager).



When you are done, click the Next button to proceed to the Detaching database step of the wizard.