| title | log_shipping_primary_databases (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 06/10/2016 | ||
| ms.prod | sql-non-specified | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 56888756-a798-42be-9b5e-0f9aa05a2cc6 | ||
| caps.latest.revision | 30 | ||
| author | JennieHubbard | ||
| ms.author | jhubbard | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Stores one record for the primary database in a log shipping configuration. This table is stored in the msdb database.
| Column name | Data type | Description |
|---|---|---|
| primary_id | uniqueidentifier | The ID of the primary database for the log shipping configuration. |
| primary_database | sysname | The name of the primary database in the log shipping configuration. |
| backup_directory | nvarchar(500) | The directory where transaction log backup files from the primary server are stored. |
| backup_share | nvarchar(500) | The network or UNC path to the backup directory. |
| backup_retention_period | int | The length of time, in minutes, that a log backup file is retained in the backup directory before being deleted. |
| backup_job_id | uniqueidentifier | The [!INCLUDEmsCoName] [!INCLUDEssNoVersion] Agent job ID associated with the backup job on the primary server. |
| monitor_server | sysname | The name of the instance of the [!INCLUDEmsCoName] [!INCLUDEssDEnoversion] being used as a monitor server in the log shipping configuration. |
| monitor_server_security_mode | bit | The security mode used to connect to the monitor server. 1 = Windows Authentication. 0 = [!INCLUDEssNoVersion] Authentication. |
| last_backup_file | nvarchar(500) | The absolute path of the most recent transaction log backup. |
| last_backup_date | datetime | The time and date of the last log backup operation. |
| user_specified_monitor | bit | [!INCLUDEssInternalOnly] sp_help_log_shipping_primary_database and sp_help_log_shipping_secondary_primary use this column to control the display of monitor settings in [!INCLUDEssManStudioFull]. 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. |
| backup_compression | tinyint | 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 [!INCLUDEssNoVersion]. |
About Log Shipping (SQL Server)
sp_add_log_shipping_primary_database (Transact-SQL)
sp_delete_log_shipping_primary_database (Transact-SQL)
sp_help_log_shipping_primary_database (Transact-SQL)
System Tables (Transact-SQL)