Hello All !
I have a DRP solution with logshipping (1 site in Europe and 1 site in Asia). The DRP are tested: ok.
3 servers: 1 primary, 1 standby, 1 monitor (sql 2008 edt enterprise US SP1 x64) on Windows 2008 SP2 US x64 with the last updates.
But , on my logs-hipping monitor, I always have this message (I have it when log-shipping installation was configured):
Executed as user: PROD\svc_sqla_bb. The log shipping secondary database Server001.DBAS has restore threshold of 45 minutes and is out of sync. No restore was performed for 96 minutes. Restored latency is 0 minutes. Check agent log and logshipping monitor information.
[SQLSTATE 42000] (Error 14421). The step failed."
- All the servers have the same time
- All the servers have been updated with the last updates (windows, sql)
- Network latence is correct
- Log shipping is functional: backup, restore: ok
I have searched on the web for this message, but I don't find a good solution for this issue .
Any ideas ?
Thanks for advance for your ideas / help - Regards - Have a nice day ! RHUM2
View Complete Post