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