December 7, 2006 at 10:03 am
Hi there,
I''m working on setting up the standby servers using log shipping.
All servers are SQL2000 Standard Edition. We wrote scripts to do the job
We have daily full backup and transaction log backup every 15 minutes on the primary servers.
The log shipping processes generate additional transaction log backups on the standby server every 5 minutes.
When run the process, we got error like this:
“The log in this backup set begins at LSN 761000000034500001, which is too late to apply to the database. An earlier log backup that includes LSN 761000000034300001 can be restored.”
It looked like the two sets of log backups(one on the primary, the other on standby) was the culprit.
What is the best way to handle situation like this?
Any suggestions/comments? Any assistance appreciated.
Best,
Walter.
December 7, 2006 at 1:17 pm
Might be you tlog backups missing...
Check it out if you have any un restored tlog backups...
Solution without restoring full db is take the differential backup and apply to the standby server to continue your tlog restores.
MohammedU
Microsoft SQL Server MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply