Sunday, November 20, 2011

SQL Server 2008: Cannot Detach The Database


You have a dead file for a database that was active. For example, you have lost a disk drive or if you have lost file MDF file. Now you try to detach it from the SQL Server Management Studio, it won't let you do it.


Try manually firing the query then

use master
drop database

The key above is that you are going to the master and not any other databases.

No comments: