logshipping monitoring jobs | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

logshipping monitoring jobs

We alredy have configured logshipping here . The issue here is that we want to detect Each time a log is received (detected), a job on the DR box could write to a table the log file name and `received’ and each time a log is restored, a job would write to the table for that log file, `restored’. We’ll also need monitoring jobs to check for when this gets too far behind (ie: There are 10 logs waiting to be restored on DR node \blah" or "No logs have been received for 3 hrs on DR node \blah"). I wanted to know where i could find this or is it possible
Why you want to invent the wheel as you have the log shipping monitor in this case? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.