नोट
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप साइन इन करने या निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
इस पृष्ठ तक पहुंच के लिए प्राधिकरण की आवश्यकता होती है। आप निर्देशिकाएँ बदलने का प्रयास कर सकते हैं।
Applies to: 
SQL Server
This stored procedure retrieves the settings for a given primary database on the secondary server.
Transact-SQL syntax conventions
Syntax
sp_help_log_shipping_secondary_primary
[ @primary_server = ] N'primary_server'
, [ @primary_database = ] N'primary_database'
[ ; ]
Arguments
[ @primary_server = ] N'primary_server'
The name of the primary instance of the SQL Server Database Engine in the log shipping configuration. @primary_server is sysname, with no default.
[ @primary_database = ] N'primary_database'
The name of the database on the primary server. @primary_database is sysname, with no default.
Return code values
0 (success) or 1 (failure).
Result set
The result set contains the following columns from log_shipping_secondary.
| Column name | Data type | Description |
|---|---|---|
secondary_id |
uniqueidentifier | The ID for the secondary server in the log shipping configuration. |
primary_server |
sysname | The name of the primary instance of the SQL Server Database Engine in the log shipping configuration. |
primary_database |
sysname | The name of the primary database in the log shipping configuration. |
backup_source_directory |
nvarchar(500) | The directory where transaction log backup files from the primary server are stored. |
backup_destination_directory |
nvarchar(500) | The directory on the secondary server where backup files are copied to. |
file_retention_period |
int | The length of time, in minutes, that a backup file is retained on the secondary server before being deleted. |
copy_job_id |
uniqueidentifier | The ID associated with the copy job on the secondary server. |
restore_job_id |
uniqueidentifier | The ID associated with the restore job on the secondary 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. |
secondary_connection_options |
nvarchar(4000) | Additional connection options for the connection made between the log shipping executable and the secondary replica instance. Available starting with SQL Server 2025 (17.x) and later versions. |
monitor_connection_options |
nvarchar(4000) | Additional connection options for the connection made between the secondary replica instance and the remote monitor. Available starting with SQL Server 2025 (17.x) and later versions. |
Remarks
sp_help_log_shipping_secondary_primary must be run from the master database on the secondary server.
Permissions
Only members of the sysadmin fixed server role can run this procedure.