Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Maps each primary database to its secondary databases. 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. |
secondary_server |
sysname |
The name of the secondary instance of the Microsoft SQL Server Database Engine in the log shipping configuration. |
secondary_database |
sysname |
The name of the secondary database in the log shipping configuration. |
See Also
Reference
sp_add_log_shipping_primary_secondary (Transact-SQL)
sp_delete_log_shipping_primary_secondary (Transact-SQL)
sp_help_log_shipping_primary_secondary (Transact-SQL)