log_shipping_primary_databases (Transact-SQL)
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 Microsoft SQL Server Agent job ID associated with the backup job on the primary server. |
monitor_server |
sysname |
The name of the instance of the Microsoft SQL Server Database Engine 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 = SQL Server 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 |
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. |
See Also
Reference
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)
Other Resources
How to: View the Log Shipping Report (SQL Server Management Studio)
Log Shipping
Log Shipping Tables and Stored Procedures