|
I deleted contents of a table accidentally; I am not able to recover the deleted content now. Unfortunately there is no backup file for this table. I have made a copy of the .mdf file but again the SQL Server was running when I made the copy. Can anybody let me know how this deleted data can be recovered?
(comments are locked)
|
|
You can give the .mdf file a try. However as per my knowledge this file cannot be used if the copy is taken when the SQL Server is running. You can use the Lumigent's Log Explorer to roll back the transaction in the server, however this can be used only if your database is in full recovery mode. This does not work when your database is in simple recovery mode
(comments are locked)
|
Your answer
