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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.