Log Shipping Error

[krotha]

Hi, I am getting error while restoring log shipping.

My History shows like this:
copy succeeded Tlog_1400
Load Succeeded Tlog_1400
Copy Suceeded Tlog_1430
Load Failure Tlog_1400
Copy Suceeded Tlog_1500
Load Failure Tlog_1400

It loaded last 2 days transaction logs. Today it is giving errors. Why it is trying to load 1400 again instead of 1430. I tried Manually restoring logs, But no luck.



[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4305: [Microsoft][ODBC SQL Server Driver][SQL Server]The log in this backup set begins at LSN 967000000001600002, which is too late to apply to the database. An earlier log backup that includes LSN 929000000035500001 can be restored.
[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally.

Any help please.

 

[JayKusch]

A quick fix is to stop the log shipping on that DB for a moment.

Go ahead and create another full backup of the DB, move it over to the warm standby server and apply the backup w/ the NO RECOVERY option set to true.

Start log shipping back up and see if this corrects the issue.

Thanks

J. Kusch