O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required