SQL Log Rescue box shot

SQL Log Rescue

Walk-through: Recovering lost data

This walk-through will show you:

  • How to set up a new project
  • How to view transactions
  • How to identify a problem
  • How to recover data
Stop walk-through

Step 1: Executing a dangerous query on our database

Executing a dangerous query

We'll start this walk-through by viewing a database and executing a damaging transaction on it.

By re-running the original query, we can see that our data has been permanently deleted.

Server:Msg 208, Level16, State 1, Line 1
Invalid object name 'socceradmin.players'.

We now want to go ahead and rescue our data.