I am using Redgate SQL Backup to log ship to a couple of destination servers and I also monitor this using the Log Shipping Monitor.
Recently the restore job has been in a "stuck" state on one or the other servers, mainly over the weekend when i'm not in the office to check the monitor.
I was wondering if anyone knows a way of setting up an email alert like the Microsoft Log shipping SQL Alert to send alerts to a blackberry or other device if the source and destination servers are not in synch.
Recently the restore job has been in a "stuck" state on one or the other servers, mainly over the weekend when i'm not in the office to check the monitor.
I was wondering if anyone knows a way of setting up an email alert like the Microsoft Log shipping SQL Alert to send alerts to a blackberry or other device if the source and destination servers are not in synch.