The windows got crashed and we copied the file from hdd to other machine..... Let me explain you ..
We have this db since many years one day the c:drive got full so the dba make changes and create new log and mdf in different drive which will save the ongoing data and old data will remain in C:\
we are also able to get old and new data through one DB only. Now machine/windows got crashed and we copied the file into another system/server. We are able to restore the c:drive mdf but other drive mdf giving error it is not a primary database file. Please Help Thanks
I have a database which have multiple MDF files and one log file.
- database_log.ldf both files are in c drive.
- database.mdf which is in another E drive
Now, When I am attaching the database.mdf(mentioned in point 1) is attaching but the database.mdf which is in another drive is not appearing.