how can i go back to an earlier backup

Undo for SQL Server.

Moderator: eddie davis

how can i go back to an earlier backup

Postby mtlFranck » Wed Aug 22, 2007 3:08 pm

here is the problem
i had a huge crash (50 000 record lost) 2 weeks ago
last week i manage to get the records back but my clients want to know why it crashed
however an other backup was made between
so sql log rescue only sees up until the last backup and not before

is there a way to go back to before the current backup??
mtlFranck
 
Posts: 2
Joined: Wed Aug 22, 2007 3:00 pm

what i tried

Postby mtlFranck » Wed Aug 22, 2007 3:23 pm

i alreaddy tried to restore my database with the old backup and run sql log rescue
but it seems that when a database is restored the transaction log gets cleared
so i need to be able to access the old transaction log
mtlFranck
 
Posts: 2
Joined: Wed Aug 22, 2007 3:00 pm

Postby Robert » Thu Aug 23, 2007 8:20 am

Hi,

Do you have transaction log backups as well, or just full backups? If you do, you might want to try only specifying the earlier full backup and all the transaction log backups rather than giving SLR the latest full backup.

Hope that helps,
Robert
Robert Chipperfield
Red Gate
Robert
 
Posts: 410
Joined: Mon Oct 30, 2006 11:15 am
Location: Cambridge, UK


Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests