Red Gate forums :: View topic - how can i go back to an earlier backup
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

how can i go back to an earlier backup

Search in SQL Log Rescue forum
Post new topic   Reply to topic
Jump to:  
Author Message
mtlFranck



Joined: 22 Aug 2007
Posts: 2

PostPosted: Wed Aug 22, 2007 3:08 pm    Post subject: how can i go back to an earlier backup Reply with quote

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



Joined: 22 Aug 2007
Posts: 2

PostPosted: Wed Aug 22, 2007 3:23 pm    Post subject: what i tried Reply with quote

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



Joined: 30 Oct 2006
Posts: 428
Location: Cambridge, UK

PostPosted: Thu Aug 23, 2007 8:20 am    Post subject: Reply with quote

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
Developer, Red Gate Software Ltd
Back to top
View user's profile Send private message MSN Messenger
Display posts from previous:   
Reply to topic 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