I have a SQL Server database that I wrongly executed a delete script on it that removed an important records from a filestream-enabled table called
after the execution immediately I created a backup, now this backup contains a big
.LDF log file and also the filestream folder container contains the files that its records were removed.
Using the Dedicated Admin Connection I were able to see the file stream tombstone tables, for the backup I have the filestream tombstone table contains a lot of records which I think indicates to the removed records, but am I able to recover the whole rows or to get the row ID from the information provided in this table ?
The following data are provided by the tombstone table :
oplsn_fseqno oplsn_bOffset oplsn_slotid file_id rowset_guid column_guid filestream_value_name ---> I used this value to go to the physical file in the filstream container and its existed. transaction_sequence_num status
Using a recovery application I were able to recover almost all the records in the other tables, even the
Imagestable rows restored, but the
Datacolumn which is the filestream column always contains 48-byte long binary data that you can see an example of them from here, I'm wondering how can I use this data to link them to a "tombstone" row or maybe to get the their file name in the filestream container file ?