sp-delete-log-shipping-secondary-database-transact-sql.md

title	sp_delete_log_shipping_secondary_database (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sp_delete_log_shipping_secondary_database_TSQL sp_delete_log_shipping_secondary_database
dev_langs	TSQL
helpviewer_keywords	sp_delete_log_shipping_secondary_database
ms.assetid	c71b21c0-ec04-4fbd-9735-01128b736935
author	MashaMSFT
ms.author	mathoma

sp_delete_log_shipping_secondary_database (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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

Transact-SQL Syntax Conventions

Syntax

  
sp_delete_log_shipping_secondary_database  
[ @secondary_database = ] 'secondary_database'  

Arguments

[ @secondary_database = ] 'secondary_database' Is the name of the secondary database. secondary_database is sysname, with no default.

Return Code Values

0 (success) or 1 (failure)

Result Sets

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.

See Also

About Log Shipping (SQL Server)
System Stored Procedures (Transact-SQL)