SQL Server Performance

logshipping monitoring jobs

Discussion in 'SQL Server 2005 Log Shipping' started by jasmin123, Apr 1, 2007.

  1. jasmin123 New Member

    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
  2. satya Moderator

    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
    http://www.SQL-Server-Performance.Com
    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.

Share This Page