pre-full backup rescue

EddieXEddieX Posts: 2
edited October 19, 2006 1:57PM in SQL Log Rescue
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.

Thanks

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
This discussion has been closed.