Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This topic explains how to remove a secondary database from a log shipping configuration using Microsoft SQL Server Management Studio.
To remove a secondary server
Right-click the database you want to use as your primary database in the log shipping configuration, and then click Properties.
Under Select a page, click Transaction Log Shipping.
Under Secondary server instances and databases, click the database you want to remove.
Click Remove.
Click OK to update the configuration.
See Also
Tasks
How to: Remove a Secondary Database (Transact-SQL)
Concepts
Log Shipping Tables and Stored Procedures