Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Log Shipping Monitor Server Expand / Collapse
Author
Message
Posted Tuesday, October 29, 2013 12:43 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 12:44 AM
Points: 91, Visits: 322
Hi,

If log shipping monitor server is down will affect entire log shipping configuration ?

All three servers are different.



Pradeep
Post #1509187
Posted Thursday, October 31, 2013 12:27 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
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
Post #1510029
Posted Thursday, October 31, 2013 12:45 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 12:44 AM
Points: 91, Visits: 322
No, its get down all the log shippings once monitor server is down.

Pradeep
Post #1510034
Posted Thursday, October 31, 2013 12:54 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
what is the status on primary and secondary job any error or findings?

Regards
Durai Nagarajan
Post #1510037
Posted Thursday, October 31, 2013 1:01 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 12:44 AM
Points: 91, Visits: 322
Yes, in both servers all databases getting alert in log shipping status report

Pradeep
Post #1510042
Posted Thursday, October 31, 2013 1:36 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
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
Post #1510051
Posted Thursday, October 31, 2013 3:17 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 12:44 AM
Points: 91, Visits: 322
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
Post #1510067
Posted Thursday, October 31, 2013 4:01 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
use msdb
select * from log_shipping_monitor_error_detail

anything on this during that period on both the servers.


Regards
Durai Nagarajan
Post #1510085
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse