Log shipping restore fail
Posted on 2006-11-26
I have this error msg with the log shipping, I checked in the backup folder and confirmed that the backup log file still exists, but I'm confuse which lsn mean here in the error msg? so is there any chance for me to retsore the log backup, this is very huge db 300Gb and I think full db restore will take a lot of time.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4305: [Microsoft][ODBC SQL Server Driver][SQL Server]The log in this backup set begins at LSN 124192000015036000001, which is too late to apply to the database. An earlier log backup that includes LSN 124191000020139000001 can be restored.
[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally.