Database hidden in SQL Server
Posted
by Colin Desmond
on Server Fault
See other posts from Server Fault
or by Colin Desmond
Published on 2009-12-07T23:40:23Z
Indexed on
2010/03/29
5:03 UTC
Read the original article
Hit count: 366
During an aborted TFS import (2008 into 2010), I have managed to "lose" a database in 2008. The database is not visible in Management Studio, but the SQL Server exe has a handle on the .mdf file (according to UnLocker), it says it cannot attach it because the file is in use and it cannot attach a copy of the file (created when SQL Server was stopped), as it says a DB of the same name is already attached.
Given I am using the same TFS admin account I have always used and have always been able to see the database in, why is this database missing and, more importantly, how do I get it back again?
© Server Fault or respective owner