To detach a database In SQL Server Management Studio Object Explorer, connect to the instance of the SQL Server Database Engine and then expand the instance. Expand Databases , and select the name of the user database you want to detach. 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. Right-click the database name, point to Tasks , and then click Detach . The Detach Database dialog box appears. 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 de...