Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

How to: Remove a Secondary Database (SQL Server Management Studio)

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

  1. Right-click the database you want to use as your primary database in the log shipping configuration, and then click Properties.

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

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

  4. Click Remove.

  5. Click OK to update the configuration.

Community Additions

© 2015 Microsoft