pre-full backup rescue

Undo for SQL Server.

Moderator: eddie davis

pre-full backup rescue

Postby EddieX » Thu Oct 19, 2006 5: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.

Thanks
EddieX
 
Posts: 1
Joined: Thu Oct 19, 2006 5:04 pm

Postby Brian Donahue » Thu Oct 19, 2006 6: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: 6668
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests