Recovering lost data
The situation
You notice that a table that contains vital information has been dropped from your database. It has been two hours since the last database backup was made, and you need to recover the data as soon as possible.
Key challenges
- Identifying the cause of the problem.
- Recovering the data as quickly as possible.
- Minimizing the impact on your business resulting from the error.
How we can solve it
- Use SQL Log Rescue to analyze the transaction log and view the operations that have occurred.
- Find the table drop in the list of operations, using SQL Log Rescue's searching and sorting features.
- Select the table drop operation and start SQL Log Rescue's Undo wizard.
- Automatically generate a SQL script to undo the drop.
- Run the script to recreate the table.
To learn more, take a look at our worked example.
Benefits of our solution
- SQL Log Rescue™ reads the live transaction logs and transaction log backups so that you can review the operations.
- A graphical user interface makes SQL Log Rescue easy to use, eliminating the need for expensive specialists or consultants.
- You can install SQL Log Rescue after the event – it doesn't have to be running when the incident occurs.
- SQL Log Rescue integrates with SQL Backup, Red Gate's tool for speeding up, compressing, and encrypting SQL Server backups.
Online help
- SQL Log Rescue: Worked example, Getting Started
