Understanding Log Shipping

Log shipping is used to provide high-latency redundant storage for your databases. You could call log shipping database copying instead of database mirroring. While database mirroring provides an automated way to keep a duplicate copy of your database and optionally provide automatic failover, log shipping provides only the first benefit and does not offer the same low-latency benefits. Database mirroring is said to have low latency because the transactions are applied to the mirrored database very quickly. Log shipping is usually implemented with high latency because there is a longer interval, usually measured in minutes or greater, between the time when the production database is updated and the time when the standby ...

Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond now with O’Reilly online learning.

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