August 12, 2003 at 7:40 am
I am new to log shipping and began a test yesterday. I set up a primary, secondary, and monitor server to backup, copy, and restore every 5 minutes. It ran great until 4am this morning. Since then, I get this error message: "[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4305: [Microsoft][ODBC SQL Server Driver][SQL Server]The log in this backup set begins at LSN 3842000000026500001, which is too late to apply to the database. An earlier log backup that includes LSN 3840000000035500001 can be restored.
[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating abnormally."
The job restore history looks like this:
Copy Succeeded 4:00am 1 file Log#555.trn
Load Succeeded 4:00am 1 file Log#555.trn
Copy Succeeded 4:05am 2 file Log#605.trn
Load Failed 4:05am 1 file Log#555.trn
And so on....
After the error, the copies are good, but the load keeps showing Log#555.trn.
Any ideas?
August 17, 2003 at 5:24 pm
Try applying the logs manually or restart the log shipping.
August 17, 2003 at 5:47 pm
This was a cross-post. There's additional comments made at...
Cheers,
- Mark
Cheers,
- Mark
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply