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

Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.