sp_delete_log_shipping_secondary_database (Transact-SQL)

Applies to: SQL Server

This stored procedure removes a secondary database and removes the local history and remote history.

Transact-SQL syntax conventions

Syntax

syntaxsql

sp_delete_log_shipping_secondary_database
    [ @secondary_database = ] N'secondary_database'
    [ , [ @ignoreremotemonitor = ] ignoreremotemonitor ]
[ ; ]

Arguments

[ @secondary_database = ] N'secondary_database'

The name of the secondary database. @secondary_database is sysname, with no default.

[ @ignoreremotemonitor = ] ignoreremotemonitor

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

Return code values

0 (success) or 1 (failure).

Result set

None.

Remarks

sp_delete_log_shipping_secondary_database must be run from the master database on the secondary server.

Permissions

Only members of the sysadmin fixed server role can run this procedure.

Related content

• About log shipping (SQL Server)
• System stored procedures (Transact-SQL)