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).
master
, model
,msdb
,tempdb
databases are available as these are in default location. The unavailable databases were in custom locations (in moved folder).
master
database still available in SSMS when connecting to the server?