Export (0) Print
Expand All
Expand Minimize

sp_create_log_shipping_monitor_account

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.

Syntax

sp_create_log_shipping_monitor_account [ @password = ] 'password'

Arguments

[@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)

Remarks

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.

Permissions

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

Examples

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

EXEC sp_create_log_shipping_monitor_account @password = N'Pwrdx!5'
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft