DMVs Waits Cookbook Scripts XEvents SPs Catalog Functions Errors T-SQL Arch Ops
high availability
#high-availability#remove-a-secondary-database

Remove a secondary database

ﾃ Summarize this article for me This article describes how to remove a log shipping secondary database in SQL Server by using SQL Server Management Studio or Transact-SQL.

ﾃ

This article describes how to remove a log shipping secondary database in SQL Server by using

Management Studio or Transact-SQL.

  1. Connect to the instance of SQL Server that is currently the log shipping primary server

and expand that instance.

  1. Expand

, right-click the log shipping primary database, and then select.

  1. Under

, select.

  1. Under

, select the database you want to

remove.

  1. Select.

  2. Select

to update the configuration.

  1. On the primary server, execute

sp_delete_log_shipping_primary_secondary

to delete the

information about the secondary database from the primary server.

  1. 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,

is invoked from

and deletes the entry for the secondary

ID and the copy and restore jobs.

sp_delete_log_shipping_secondary_primary sp_delete_log_shipping_secondary_database