How to: Remove Log Shipping (SQL Server Management Studio)

This topic explains how to remove log shipping using Microsoft SQL Server Management Studio.

To remove log shipping

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. Clear the Enable this as a primary database in a log shipping configuration check box.

4. Click OK to remove log shipping from this primary database.

See Also

Tasks

How to: Remove Log Shipping (Transact-SQL)

Concepts

Log Shipping Tables and Stored Procedures

Other Resources

Log Shipping

Help and Information

Getting SQL Server 2005 Assistance