How to: Detach a Database (SQL Server Management Studio)

To detach a database

  1. In SQL Server Management Studio Object Explorer, connect to the instance of the SQL Server Database Engine and then expand the instance.

  2. Expand Databases, and select the name of the user database you want to detach.

  3. Detaching a database requires exclusive access to the database. If the database is in use, restrict access to a single user:

    • Right-click the database name and point to Properties.

    • In the Select a page pane, select Options.

    • In the Other options pane, scroll down to the State options.

    • Select the Restrict Access option, and in its drop-down list, select Single.

    • Click OK.

      A message box appears to inform you that this action will close all connections to the database. To proceed, click OK.

  4. Right-click the database name, point to Tasks, and then click Detach. The Detach Database dialog box appears.

  5. The Databases to detach grid displays the name of the selected database in the Database Name column. Verify that this is the database you want to detach.

  6. By default, the detach operation retains any out-of-date optimization statistics when detaching the database; to update the existing optimization statistics, click the Update Statistics check box.

  7. By default, the detach operation keeps any full-text catalogs that are associated with the database. To remove them, clear the Keep Full-Text Catalogs check box.

  8. The Status column displays the current database state (either Ready or Not Ready).

    If the status is Not Ready, the Message column displays hyperlinked information about the database. When a database is involved with replication, the Message column displays Database replicated. When a database has one or more active connections, the Message column displays Active connections; for example, 1 Active connection(s). Before you can detach the database, you must disconnect any active connections by selecting the Drop Connections check box.

    To obtain more information about a message, click the hyperlink.

  9. When you are ready to detach the database, click OK.


How to: Detach a Database (SQL Server Management Studio): "- Sent using Google Toolbar"

Comments

Post a Comment

Popular posts from this blog

How to use the Inbox Repair Tool to recover messages in Outlook 2000 that is installed with Internet Mail Only option

How to use the Inbox Repair Tool to recover messages in Outlook 2000 that is installed with Internet Mail Only option http://goo.gl/bL7i in reference to: "How to use the Inbox Repair Tool to recover messages in Outlook 2000 that is installed with Internet Mail Only option" - How to use the Inbox Repair Tool to recover messages in Outlook 2000 that is installed with Internet Mail Only option ( view on Google Sidewiki )
Read more

ReadyNAS default login and password

Prior to RAIDiator 4.0, the default login and password is 'admin' and 'infrant1'. Starting with RAIDiator 4.0, login and password is 'admin' and 'netgear1'. Please make sure you change the admin password after doing a factory default. http://goo.gl/Na7L in reference to: "Prior to RAIDiator 4.0, the default login and password is 'admin' and 'infrant1'. Starting with RAIDiator 4.0, login and password is 'admin' and 'netgear1'. Please make sure you change the admin password after doing a factory default." - NETGEAR ReadyNAS • Frequently Asked Questions ( view on Google Sidewiki )
Read more

Repair corrupt Outlook PST files with two Microsoft utilities

Outlook PST file corruption is a fairly common occurrence. To help you troubleshoot PST failures, Microsoft provides two handy utilities: the Inbox Repair Tool and the Oversized OST And PST Crop Utility. in reference to: "Outlook PST file corruption is a fairly common occurrence. To help you troubleshoot PST failures, Microsoft provides two handy utilities: the Inbox Repair Tool and the Oversized OST And PST Crop Utility." - Repair corrupt Outlook PST files with two Microsoft utilities ( view on Google Sidewiki )
Read more