Detach Database
Use this dialog box to view or specify the following options.
Options
Clear
Clear any connection to the selected database.
Connections using this database
View the number of connections to the selected database. You cannot detach a database while users are connected.
Database being replicated
View if the database is being replicated. You cannot detach a database while it is being replicated.
Status
View the status of the database. This will tell you if the database is ready to be detached, based on the criteria in the previous options.
Update statistics prior to detach
Update the database statistics prior to detaching the database.