Press "Enter" to skip to content

Detaching Corrupt Databases

Arun Sirpal explains when you can detach a corrupt database:

More specifically it depends on the SQL Server version. SQL 2005 and prior it was possible, with the newer versions of SQL you will not be able to issue the command.

So let’s confirm this with SQL 2016.

As Arun notes, there’s usually not much value in doing this as detaching a database doesn’t fix anything.