O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

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

Managing Log Shipping

Log shipping is used to establish one or more secondary databases that can be brought online manually if a primary database fails. Following is an overview of log shipping and then a discussion of how it is implemented.

Log Shipping: How It Works

Log shipping requires at least two separate SQL Server instances:

  • A primary server instance on which you have configured a database to act as the primary for log shipping

  • A secondary server instance on which you have configured a database to act as the secondary for log shipping

All administration of the log shipping configuration is performed on the primary server. You can extend log shipping in several ways:

  • By configuring multiple secondary databases, you can establish multiple standbys ...

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