sys.sp_refresh_log_shipping_monitor

Description

This stored procedure refreshes the remote monitor tables with the latest information from a given primary or secondary server for the specified log shipping agent. The procedure is invoked on the primary or secondary server. The primary ID for backup or the secondary ID for copy or restore.

Syntax

sp_refresh_log_shipping_monitor
[ @agent_id = ]
'agent_id'
, [ @agent_type = ] agent_type
[ , [ @database = ]
N
'database'
]
, [ @mode = ] mode
[ ; ]

Permissions

must be run from the database on the primary or secondary server. Only members of the fixed server role can run this procedure. About log shipping (SQL Server) System stored procedures (Transact-SQL)