How to detach and attached databases

This article will cover one of the most common SQL Server Detach and Attach the database.

 please make sure you have a recent backup for any case of data loss. If you are not used in computer administration and database administration.


Please go to Start >> Programs >>Microsoft SQL Server 2012 >> SQL Server Management Studio and open the application.

Connect with Windows Authentication (You have Windows administration rights) or

Connect with SQL Server Authentication (You have no Windows administration rights)

Expand the folder Databases in the object explorer, right-click the database you want to detach and select Tasks -> Detach as shown in the screenshot.

will open a new window. Simply leave it as is and click OK to detach the database.

Successful detachment the window automatically closes and the database is not listed in the Object Explorer.

Related posts