1
vote
1answer
136 views

Using “Generate Scripts” with EMERGENCY/SINGLE USER mode

I am trying to create an INSERT script to salvage data from a single table in a corrupt database. I've succesfully put the database online and put it in EMERGENCY / SINGLE USER mode (following this ...
7
votes
1answer
7k views

How can I recover data from the LDF file?

We are using SQL 2005 Express Edition. We want to read the data from the LDF file in order to restore some deleted records. We tried using a trial version of ApexSQL which helped us a lot. Instead of ...
6
votes
2answers
3k views

Recover accidentally deleted rows from a table

My client has accidentally deleted all the records of a table from a test database. This test database is in SQL Server 2005 Express and we don't have a backup. Is it possible to restore the deleted ...