DR Log Shipping Alerts
Is there any easy way of monitoring the status on the BTS Server Log Shipping Restore Databases job on the DR SQL instance so we can raise alerts if it fails?
We have a client who has a cluster on both the production and DR side so 4 SQL servers total.
I suggested we could set up alerting based on an SQL query but was wondering if there’s a simpler way.
By Jason Gill