June 29, 2006 at 10:07 am
Is there a way to perform a restore when you are missing of of the tlog backups in SQL? Is there a work-around to get it to skip or create a fake tlog so that the restore process will continue?
Thanks,
RJB
June 29, 2006 at 10:33 am
You will still be able to restore from a complete backup, but if you are planning on rolling forward by applying tlog backups, you must have all of the tlog backups as they must be applied in the correct order. This is a data integrity issue and you would not want to 'skip' a transaction log. You can only restore up to the missing tlog.
June 29, 2006 at 10:40 am
Thanks...the missing tlog is from a time where no changes to the DB were made so we know it would be safe to skip it. The problem is that unless we can skip it, we are going to lose a full day of data entry into a system that gets a lot of traffic. I was hoping there was a work-around or a way to trick the system? Maybe to create a fake tlog so it would continue on?
June 30, 2006 at 11:23 am
LSN has to match. Unless there is a program which can do that...Next time think about making Diff backup at least once a day. By the way, can you restore missing TLog from the tape?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply