sql server - How to delete (localdb) database if the file is gone

Question

If I run SQL Server Management Studio, and tell it to connect to (localdb)v11.0, it knows about every database I've ever used, despite the fact that most of the the database files are long gone.

If I ask it to delete one of these databases, it complains that it can't DROP the database because the database file is gone (duhhh). So, how do I clean up this mess and delete all of database references whose assicated database files are gone?

Bob

question from:https://stackoverflow.com/questions/13411005/how-to-delete-localdb-database-if-the-file-is-gone

Answer 1

In this situation, detach the database rather than trying to drop it. In SQL Management Studio, right-click on the database, select "Tasks" then "Detach".