how can i go back to an earlier backup
mtlFranck
Posts: 3
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??
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
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
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
Red Gate