Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize


SQL Server 2000

  New Information - SQL Server 2000 SP3.

Creates the log_shipping_monitor_probe login on the monitor server, and assigns update permissions to msdb.dbo.log_shipping_primaries and msdb.dbo.log_shipping_secondaries tables.


sp_create_log_shipping_monitor_account [ @password = ] 'password'


[@password =] 'password'

Is the password for the log_shipping_monitor_probe account. password is sysname, with a default of NULL.

Security Note  NULL passwords are not recommended.

Return Code Values

0 (success) or 1 (failure)


The log_shipping_monitor_probe account is used by the primary and secondary servers to update msdb.dbo.log_shipping_primaries and msdb.dbo.log_shipping_secondaries tables when a transaction log has been backed up, copied, or restored.


Only the members of the sysadmin fixed server role can execute sp_create_log_shipping_monitor_account.


This example creates a log shipping monitor account with the password Pwrdx!5.

EXEC sp_create_log_shipping_monitor_account @password = N'Pwrdx!5'
© 2015 Microsoft