Red Gate forums :: View topic - pre-full backup rescue
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Log Rescue
SQL Log Rescue forum

pre-full backup rescue

Search in SQL Log Rescue forum
Post new topic   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
EddieX



Joined: 19 Oct 2006
Posts: 1

PostPosted: Thu Oct 19, 2006 5:19 pm    Post subject: pre-full backup rescue Reply with quote

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
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6589

PostPosted: Thu Oct 19, 2006 6:57 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group