how can i go back to an earlier backup

mtlFranckmtlFranck Posts: 3
edited August 23, 2007 3:20AM in SQL Log Rescue
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??

Comments

  • 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
  • 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
Sign In or Register to comment.