I have a sql 2008 database that had a filestream. Unfortunately, all I have is the .mdf and .ldf files. I no longer have access to the filestream .hdr file or anything that was in that directory.
Normally, you can just reattach the database to a new server; but sql server refuses to do that.
The error message I get is
Unable to open the physical file "c:\". Operating system error 2: "2(The system cannot find the file specified.)".
That error shows up when I try to use the DDL command to CREATE DATABASE FOR ATTACH.
What's the trick?
Thanks
Best Answer
In SQL 2K5 I've had this happen.
I create a new db, name it whatever you want. take it offline, go into preferences and attach the .mdf and .ldf files as replacements accordingly. It's worked for me a few times, but not sure on SQL 2k8.
Good luck