I've corrupted the files related to FILESTREAM in a database.
.ldf files are still intact, but when I try to get the database online, it complains, saying that the files related to FILESTREAM are incorrect.
I don't care about the data stored in FILESTREAM, but I do care about the other data. Can I get it back from
.ldf files? How?
When I execute:
sp_attach_db @dbname = 'Demo', @filename1 = N'<File path>.mdf', @filename2 = N'<File path>.ldf'
the response is:
Msg 5120, Level 16, State 105, Line 1 Unable to open the physical file "<Location>". Operating system error 2: "2(The system cannot find the file specified.)". Msg 5105, Level 16, State 14, Line 1 A file activation error occurred. The physical file name '<Location>' may be incorrect. Diagnose and correct additional errors, and retry the operation. Msg 1813, Level 16, State 2, Line 1