Name of the primary instance in the log shipping configuration.
Name of the primary database in the log shipping configuration.
Backup Source Directory
Directory where transaction log backup files from the primary server are stored.
Name of the instance being used as a monitor server in the log shipping configuration.
Last Copied Date
Date and time of the last copy operation to the secondary server.
Name of the secondary database in the log shipping configuration.
Amount of time that the secondary server will wait before restoring a given backup file. The default is 0 minutes.
Last Restored Date
Date and time of the last restore operation on the secondary database.
Name of the secondary instance in the log shipping configuration.
Last Restored Latency
Amount of time that elapsed between the log backup being created on the primary and when it was restored on the secondary.
History Retention Period
Amount of time that log shipping history records are retained for the secondary database before being deleted.
Copy Job Enabled
Whether copy jobs are enabled.
Restore Job Enabled
Whether restore jobs are enabled.
Backup Destination Directory
Directory on the secondary server where backup files are copied to.
Size that is used as the block size for the backup device.
Total number of buffers used by the backup or restore operation.
Copy Job ID
ID associated with the copy job on the secondary server.
If set to Yes, users will be disconnected from the secondary database when a restore operation is performed. The default is No.
File Retention Period
How long a backup file is retained on the secondary server before being deleted.
Last Copied File
Filename of the last backup file copied to the secondary server.
Last Restored File
Filename of the last backup file restored to the secondary database.
Max Transfer Size
Size of the maximum input or output request issued by SQL Server to the backup device.
Monitor Server Security Mode
Security mode used to connect to the monitor server. For example, Windows or SQL Server.
If set to Yes, the secondary server will restore all available transaction log backups when the restore job runs. If set to No, it stops after one file has been restored.
Restore Job ID
ID associated with the restore job on the secondary server.
Restore mode for the secondary database. For example, NORECOVER, STANDBY.
Number of minutes allowed to elapse between restore operations before an alert is generated.
ID for the secondary server in the log shipping configuration.
Alert to be raised when the restore threshold is exceeded.
Threshold Alert Enabled
Whether threshold alerts are enabled. For example, Enabled, Disabled, Unknown.