| title | sp_help_log_shipping_primary_secondary (Transact-SQL) | ||
|---|---|---|---|
| description | Returns information regarding all the secondary databases for a given primary database. | ||
| author | MashaMSFT | ||
| ms.author | mathoma | ||
| ms.reviewer | randolphwest | ||
| ms.date | 06/23/2025 | ||
| ms.service | sql | ||
| ms.subservice | system-objects | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE SQL Server]
This stored procedure returns information regarding all the secondary databases for a given primary database.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_help_log_shipping_primary_secondary
[ @primary_database = ] N'primary_database'
[ ; ]
The name of the database on the primary server. @primary_database is sysname, with no default.
0 (success) or 1 (failure).
| Column name | Description |
|---|---|
secondary_server |
The name of the secondary instance of the [!INCLUDE ssdenoversion-md] in the log shipping configuration. |
secondary_database |
The name of the secondary database in the log shipping configuration. |
sp_help_log_shipping_primary_secondary must be run from the master database on the primary server.
Only members of the sysadmin fixed server role can run this procedure.
This example illustrates using sp_help_log_shipping_primary_secondary to retrieve a list of secondary databases associate with the primary database [!INCLUDE ssSampleDBobject].
EXECUTE master.dbo.sp_help_log_shipping_primary_secondary @primary_database = N'AdventureWorks';
GO