I have SQL Server 2008 Express edition installed on my machine. I had changed the location of some folders from one drive to another (from F: to E:).
Now when I connect to SQL Server using SSMS, it does not show any database. If I try to attach a database by selecting the file it show me the error that
Cannot attach a database with the same name as an existing database
How can I clean up the no-existing (for SQL Server) databases and re-attach the moved files?
Edit:- In Event Log it is showing errors like following for moved databases:
FCB::Open failed: Could not open file F:\Code\EFTest\App_Data\eftest.mdf for file number 0. OS error: 2(failed to retrieve text for this error. Reason: 15105).
tempdb databases are available as these are in default location. The unavailable databases were in custom locations (in moved folder).