March 4, 2011 at 5:45 am
Dear All,
Please advise on this.
The log shipping secondary database xxxxx.yyyyy has restore threshold of 30 minutes and is out of sync. No restore was performed for 66 minutes. Restored latency is 10 minutes. Check agent log and logshipping monitor information.
EVENT ID 14421
NOTE: Backup and Copy jobs are working fine and one more thing is intially first log backup has been restored on the secondary but after it's keep on failing..I got the above error in eventviewer.
Schedules:
Backup Job : Every 5 mins
Copy Job : Every 10 mins
Restore Job :Every 10 mins alert 30 mins
Thanks and Regards,
Ravi.
March 23, 2011 at 5:46 pm
Hi ravisamigo,
I have exactly the same issue and really no answer for the moment :(.
Questions : What is your version of SQL server ? Is it the 2008 R2 ? And have you a backup solution like DPM activated on the database where you try to use the Log Shipping ? I don't know if this information can help but this is my configuration.
20 days left since you posted your message ... Have you fixed the problem ?
Any help will be welcome ! Thanks in advance 🙂
Jalen.
March 23, 2011 at 10:12 pm
Thanks. This was already fixed.
Both Primary and Secondary are running under same service account.
Windows administrator changed the password for the service account running on Primary and missed to change for secondary.
Then I have checked with them and assigned the same password for both Primary and Secondary and restarted the services and reconfigured the logshipping..... it's working fine...
Regards,
Ravi.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply