pre-full backup rescue

[EddieX]

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

[Brian Donahue]

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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521