Skip to content

remove-a-secondary-database-from-a-log-shipping-configuration-sql-server.md

Latest commit

 

History

History
97 lines (62 loc) · 4.55 KB

remove-a-secondary-database-from-a-log-shipping-configuration-sql-server.md

File metadata and controls

97 lines (62 loc) · 4.55 KB
title Remove a Secondary Database from a Log Shipping Configuration (SQL Server) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
dbe-high-availability
ms.tgt_pltfrm
ms.topic article
helpviewer_keywords
deleting secondary databases
secondary databases [SQL Server], in log shipping
removing secondary databases
secondary data files [SQL Server], removing
log shipping [SQL Server], secondary databases
ms.assetid ebe368a4-ca1c-45d0-9a71-3ddbd5b26a8e
caps.latest.revision 19
author MikeRayMSFT
ms.author mikeray
manager jhubbard

Remove a Secondary Database from a Log Shipping Configuration (SQL Server)

This topic describes how to remove a log shipping secondary database in [!INCLUDEssCurrent] by using [!INCLUDEssManStudioFull] or [!INCLUDEtsql].

In This Topic

Before You Begin

Security

Permissions

The log-shipping stored procedures require membership in the sysadmin fixed server role.

Using SQL Server Management Studio

To remove a log shipping secondary database

  1. Connect to the instance of [!INCLUDEssNoVersion] that is currently the log shipping primary server and expand that instance.

  2. Expand Databases, right-click the log shipping primary database, and then click Properties.

  3. Under Select a page, click Transaction Log Shipping.

  4. Under Secondary server instances and databases, click the database you want to remove.

  5. Click Remove.

  6. Click OK to update the configuration.

Using Transact-SQL

To Remove a Secondary Database

  1. On the primary server, execute sp_delete_log_shipping_primary_secondary to delete the information about the secondary database from the primary server.

  2. On the secondary server, execute sp_delete_log_shipping_secondary_database to delete the secondary database.

    [!NOTE]
    If there are no other secondary databases with the same secondary ID, sp_delete_log_shipping_secondary_primary is invoked from sp_delete_log_shipping_secondary_database and deletes the entry for the secondary ID and the copy and restore jobs.

  3. On the secondary server, disable the copy and restore jobs. For more information, see Disable or Enable a Job.

Related Tasks

See Also

About Log Shipping (SQL Server)
Log Shipping Tables and Stored Procedures