Applies To: SQL Server 2014, SQL Server 2016 Preview
Stores one record for the primary database in a log shipping configuration. This table is stored in the msdb database.
Applies to: SQL Server (SQL Server 2008 through current version).
The ID of the primary database for the log shipping configuration.
The name of the primary database in the log shipping configuration.
The directory where transaction log backup files from the primary server are stored.
The network or UNC path to the backup directory.
The length of time, in minutes, that a log backup file is retained in the backup directory before being deleted.
The Microsoft SQL Server Agent job ID associated with the backup job on the primary server.
The name of the instance of the Microsoft SQL Server Database Engine being used as a monitor server in the log shipping configuration.
The security mode used to connect to the monitor server.
1 = Windows Authentication.
0 = SQL Server Authentication.
The absolute path of the most recent transaction log backup.
The time and date of the last log backup operation.
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
sp_help_log_shipping_primary_database and sp_help_log_shipping_secondary_primary use this column to control the display of monitor settings in SQL Server Management Studio.
0 = When invoking either of these two stored procedures, the user did not specify an explicit value for the @monitor_server parameter.
1 = An explicit value was specified by the user.
Indicates whether the log shipping configuration overrides the server-level backup compression behavior.
0 = Disabled. Log backups are never compressed, regardless of the server-configured backup compression settings.
1 = Enabled. Log backups are always compressed, regardless of the server-configured backup compression settings.
2 = Uses the server configuration for the View or Configure the backup compression default Server Configuration Option server-configuration option. This is the default value.
Backup compression is supported only in the Enterprise edition of SQL Server.