O'Reilly logo

SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond by Tom Carpenter

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

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

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