O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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

Log shipping is a technology that has been around for many years. It’s stable, reliable, and easy to implement. Simply put, log shipping gives you the ability to have a warm standby database or databases running in case something bad happens. The standby database can be located physically close to the primary database or on another continent. You can have one standby or multiple standby databases geographically dispersed. Additionally, log shipping gives you a very granular level of control over the current state of the standby database.

On the surface, this may sound trivial—distance and chronological history—but in reality, these are very real concerns. For example, with clustering either at the server level or at the disk storage ...

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