Log Shipping Overview

SQL Server 2000 and 7.0 provide a utility called Log Shipping. The purpose of the log shipping utility is to automatically copy and apply the log from database A to database B (see Figure 10.20) . The source and target databases can be on the same server or separate servers.

Figure 10.20. The Log Shipping overview.

The Log Shipping tool takes the changes in the source database and automatically applies them to the target database. Changes can include: data changes, schema changes, permission changes, stored procedure changes, and so on. This is different than replication, in that replication is exclusively focused on synchronizing ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.