Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2005-04-27 : 10:14:13
|
| Hi, everybody,Here are commands and error msg from my QA.RESTORE LOG ABC FROM DISK = 'c:\temp\ABC_tlog_yyyymmdd1200.trn' WITH NORECOVERY stats=5RESTORE LOG marktest FROM DISK = 'c:\temp\ABC_tlog_yyyymmdd1230.trn' WITH NORECOVERY stats=5...RESTORE LOG marktest FROM DISK = 'c:\temp\ABC_tlog_yyyymmdd2000.trn' WITH RECOVERY stats=5-----------------Server: Msg 4305, Level 16, State 1, Line 16The log in this backup set begins at LSN 825000006978300001, which is too late to apply to the database. An earlier log backup that includes LSN 825000005298000001 can be restored.Server: Msg 3013, Level 16, State 1, Line 16RESTORE LOG is terminating abnormally.-----------------BOL said:The restore operation found a gap between the last restore and the transaction log that you attempted to apply.Locate the missing, earlier transaction log backups and apply these first. Transaction logs must be restored in the same order in which they were backed up.I have double checked the name/time of these tlogs, and did not think there is a missing one or are applying them out of sequence. I highlighted all 18 of them in QA and run them in one batch. All 15 went well, but last 3 got these errors. What esle should I look for? And how to resolve it? Do those LSN numbers give any clue?BTW, I am doing above on a testing server to practice the process, so I re-run the last good tlog with WITH Recovery. The db is restored up to that point in time. Thanks!-hommer |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-04-27 : 15:56:54
|
| Could be that there was a disk error on the database - that causes out log shipping to fsil. I do it all automatically tp make sure I don't miss one.http://www.mindsdoor.net/SQLAdmin/LogShipping.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
|
|
Tlog backup error 4305