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?