Greetings all,
We have a requirment to monitor and report on SQL Log Shipping metrics
specifically the time GAP between the primary and backup databases. The
reporting elements I can handle but I am trying to figure out to collect
the SQL Log Shipping GAP data. Would the SQL_RepLatency script be the
one to use? Any help would be greatly appriciated.

_________________________________________
• PRIMARY DATABASES – Primary server and database name in the log
shipping configuration
• BACKUP DESTINATION – Standby server and database name in the log
shipping configuration
• GAP STATUS – The time difference between when the last *applied log
was created on the Primary Server and when it was applied to the Backup
Server
PLUS (+)
The amount of time that passed since the last log was applied to the
Backup Server and when the report was created
• LAST LOG APPLIED – The date and time of the last log restore on the
standby database
• Report Date – The date the csv file was last updated


--
abel5405
------------------------------------------------------------------------
abel5405's Profile: https://forums.netiq.com/member.php?userid=5035
View this thread: https://forums.netiq.com/showthread.php?t=57098