This blog is part of the blog series named SQL Server Monitoring.
Purpose
To list the log shipping configuration when the server is configured as a primary, standby, or monitoring server.
Sources
The feature queries the msdb DMV’s log_shipping_monitor_primary, log_shipping_monitor_secondary, log_shipping_primary_databases, log_shipping_primary_secondaries, log_shipping_secondary and log_shipping_secondary_databases.
Report
The report has 6 tables, 2 for monitoring configuration, 2 for primary databases configuration and 2 for secondary databases configuration.
History – drill-through page
The Log shipping configuration history page list all the configuration changes made on the log shipping configuration.
Model
The model for the report uses the facts [Log shipping monitor primary database state], [Log shipping monitor secondary database state], [Log shipping primary database state], [Log shipping primary secondary database state], [Log shipping secondary database state], [Log shipping secondary primary database state] and [Log shipping state history], and the dimensions [Database] and [Server].
Configuration
There is no configuration for this feature.
Scheduling
The default schedule for the feature is every 2 minutes (120 seconds).
Retention
The default retention for the table dbo.fhsmLogShippingState is 1.825 days (5 years).
