Administering SQL Server

Modifying Log Shipping

After log shipping has been configured, it is possible to add, delete, or edit the destination servers. For example, you can change the transaction log destination, specify if you want to create a new database on the destination server, or use an existing database. If you choose to create a new database, you must specify a database name and file directories for the data and logs.

To add or edit a destination server

Enterprise Manager

Enterprise Manager

To delete a destination server

Enterprise Manager

Enterprise Manager

To remove a log shipping pair from the log shipping monitor (Transact-SQL)

Transact-SQL

Transact-SQL