pre-full backup rescue

Undo for SQL Server.

pre-full backup rescue

Postby EddieX » Thu Oct 19, 2006 4:19 pm

So far I haven't had a need to do this but wanted to find out if it is possible with LR.

Here's the scenario:

We have a full backup, transaction logs dating back 3 months prior to the backup and logs up to present time.

A client comes to us stating that data is missing from a month prior to our full backup.

Is it possible?, using the current full backup and the transaction logs available, to see what happened and repair if needed.

Posts: 1
Joined: Thu Oct 19, 2006 4:04 pm

Postby Brian Donahue » Thu Oct 19, 2006 5:57 pm

Hi Eddie,

This should be possible using the backup files. First, get the full and log backup files from the time period you're interested in, restore the full backup to a new database, and tell SQL Backup to analyze that database, also including the full and transaction log backups up to the point of failure. This should show all of the transactions that took place between the full and final log backup so that you can undo or redo them.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests