October 29, 2013 at 12:43 am
Hi,
If log shipping monitor server is down will affect entire log shipping configuration ?
All three servers are different.
Pradeep
October 31, 2013 at 12:27 am
I dont think so, it is just for monitoring backup, copy, restore job at a common location else you have to find it primary and secondary for their respective status.
Regards
Durai Nagarajan
October 31, 2013 at 12:45 am
No, its get down all the log shippings once monitor server is down.
Pradeep
October 31, 2013 at 12:54 am
what is the status on primary and secondary job any error or findings?
Regards
Durai Nagarajan
October 31, 2013 at 1:01 am
Yes, in both servers all databases getting alert in log shipping status report
Pradeep
October 31, 2013 at 1:36 am
Log shipping status report is showing not in sync or out of threshold for "X" minutes?
Can you give the exact error that is there on the job failure restores or copy?
Regards
Durai Nagarajan
October 31, 2013 at 3:17 am
I got alert once monitor server is down.
The log shipping secondary database XXXX\XXXX.<Database Name> has restore threshold of 45 minutes and is out of sync. No restore was performed for 51 minutes. Restored latency is 9 minutes. Check agent log and logshipping monitor information
Pradeep
October 31, 2013 at 4:01 am
use msdb
select * from log_shipping_monitor_error_detail
anything on this during that period on both the servers.
Regards
Durai Nagarajan
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply