Possible to recover data from incomplete backup set?

Undo for SQL Server.

Moderator: eddie davis

Possible to recover data from incomplete backup set?

Postby rpresser » Fri Jun 02, 2006 11:10 pm

I have a problem. I have a full BAK from May 17 (which is known to be intact), and daily TRN backups from the 20th on. The TRN from the 18th is missing, and cannot be found anywhere. One or more of the existing TRNs *may* be corrupt, however I don't know because I can't restore them of course.

Can Log Explorer help me get any data out of the TRN files that I have, or am I barking up the wrong tree entirely?
rpresser
 
Posts: 7
Joined: Fri Jun 02, 2006 11:07 pm

Postby Neil Davidson » Sat Jun 03, 2006 11:07 am

It might be able to help you - it depends on what data is in the missing transaction log backup. The best bet is to try it out and see what happens.
- Neil Davidson
Red Gate Software Ltd
Neil Davidson
 
Posts: 221
Joined: Wed Sep 08, 2004 12:00 pm


Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests