Applied wrong (I thnk) log backup.
-
Hi All,
Got a serious problem.
I have been restoring a DB for the last 7 hours. When I went to restore the logs, I restored the last log prior to the backup. From what I can tell...
The file times for the log backups started after the backup time. i.e. Backup ended at 4:45am and first log backup was 9am the same day.
When I tried applying the log for 10am(9am applied fine) it complained saying the LSN's where wrong.
After looking at the LSNs for each backup, it seems that the order is:
Log
Backup
Another_Log.
Now I went and restred backup and then Log, not Another_Log.
Can I undo what I have done and apply Another_Log.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
-
Since the sequence is Backup and then log. And next cycle is the same..u would need to apply the last backup and the last log if u are trying to get the lastest db state. No u cannot undo once you have applied the log.
-
worked it out - the logs get overwritten in the backup directory.
The first log was not overwritten because the following day 9am backup did not run.
Waiting for the tapes to load
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
-
SQL Server will not allow you to apply log backups out of order so this should never happen. Before applying a log backup SQL server checks to ensure that the LSN's are in sync.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply