Export (0) Print
Expand All
Expand Minimize

Detach Database

SQL Server 2000

Use this dialog box to view or specify the following options.



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.


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.

See Also

How to attach and detach a database (Enterprise Manager)

© 2014 Microsoft