Last post Jul 13, 2018 07:56 PM by ClarkNK
Jul 13, 2018 07:56 PM|ClarkNK|LINK
I had several databases up and running on my local SQLServer 2012 Management Studio.
Today when I go to look, none of them show (see screen capture below). So I try to add one back (in this case names MyNumbersTrackerDb) with the idea I will re-attach it to the aspnetdb.mdf file in the App_Data folder of my local website. But I can't add
the database because I get the error message that the database already exists.
So the question: If it already exists, why can't I see it in the database list of SQL Server? How do I get out of this situation?
Jul 15, 2018 07:08 PM|ClarkNK|LINK
Been playing around with this for quite a while. Not sure of the sequence of things but at some point I did a Save All and suddenly the databases appeared, although most of them indicated recovery pending (which was never going to finish).
I deleted all those, and there was MyNumbersTrackerDb also showing but with no tables. So I decided to start from scratch and re-create that database. So I deleted it also, only to discover that the process deleted the aspnetdb.mdf database to which it was
attached (located in my local websites App_Data folder). Maybe I should have known that would happen, but I know just barely enough about SQLServer to get what I need going :=(
Lucky for me I kept a complete backup of the website while working on it (actually not luck, I did it just in case), so was able to replace the missing aspnetdb.mdf file in the website App_data folder.
Finally, in SSMS, I created a new MyNumbersTrackerDB and successfully attached it to the aspndb.mdf file in the websites App_Data folder. So for now, I am back in business and the database still shows up in SSMS when I close it and restart it.
I am posting this in the possibility that some other user wandering through the haze of SQLServer Managment Studio may find it useful.