Skip to content

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

Latest commit

 

History

History
70 lines (48 loc) · 3.67 KB

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

File metadata and controls

70 lines (48 loc) · 3.67 KB
title Remove Log Shipping Secondary
description Learn how to remove a log shipping secondary partner by using SQL Server Management Studio or Transact-SQL in SQL Server.
author MikeRayMSFT
ms.author mikeray
ms.reviewer randolphwest
ms.date 02/23/2026
ms.service sql
ms.subservice log-shipping
ms.topic how-to
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

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

[!INCLUDE SQL Server]

This article describes how to remove a log shipping secondary database in [!INCLUDE ssnoversion] by using [!INCLUDE ssManStudioFull] or [!INCLUDE tsql].

Use SQL Server Management Studio

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

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

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

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

  5. Select Remove.

  6. Select OK to update the configuration.

Use Transact-SQL

  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.

Permissions

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

Related tasks

Related content