Name of the primary database in the log shipping configuration.
Directory where transaction log backup files from the primary server are stored.
How long a log backup file is retained in the backup directory before being deleted.
Name of the instance being used as a monitor server in the log shipping configuration.
Last Backup Date
Date and time of the last log backup operation.
Name of the primary instance in the log shipping configuration.
How long log shipping history records are retained for the primary database before being deleted.
Backup Job Enabled
Whether backup jobs are enabled.
Whether the log shipping configuration overrides the server-level backup compression behavior. For example, Enabled, Default, Disabled. This column is available only for SQL Server 2008.
Backup Job ID
ID of the backup job on the primary server.
Network path to the backup directory on the primary server.
Number of minutes allowed to elapse between backup operations before an alert is generated.
Last Backup Date UTC
Date and time of the last transaction log backup operation on the primary database, in Coordinated Universal Time.
Last Backup File
Path and filename of the most recent transaction log backup.
Monitor Server Security Mode
Security mode used to connect to the monitor server. For example, Windows or SQL Server.
ID of the primary database.
Alert to be raised when the restore threshold is exceeded.
Threshold Alert Enabled
Whether threshold alerts are enabled.