Microsoft® SQL Server® 2012 Bible

665

Chapter 26: Log Shipping

26

Log Shipping normally involves three SQL Servers: a primary server, a warm standby server,

and a monitor server, as shown in Figure 26-1.

FIGURE 26-1

Typical log shipping confi guration.

Secondary

Secondary

Restore

Backup Job Job

Backup Share

Backup Job

Primary

Status and Restore History

Monitor Server Instance

Status and Restore History

Restore

Job

■ The primary server or source server is the main production SQL Server to which cli-

ents connect. This server contains the log shipping database. The initial full data-

base backup and subsequent transaction log backups are taken on this server. This

server should be a high-quality server with redundant disk drives.

■ The warm standby server is the backup SQL Server, otherwise known as the secondary

server. If the source server fails, it becomes the primary server. This server should

be capable of meeting the minimum performance requirements during a short-term

crisis. If your business does not allow any performance degradation, then the warm

standby server should be similar to the primary server. In the case of an offsite

disaster recovery solution, network latency should also be considered.

■ The monitor server polls both the primary server and the warm standby server by

keeping track of what fi les have been sent where, generating an alert when the two

are out of sync. A single monitor server can monitor multiple log shipping confi gu-

rations. The monitor server is optional. If a monitor server is not used, the primary

and warm standby servers store the monitoring information.

c26.indd 665c26.indd 665 7/31/2012 9:49:17 AM7/31/2012 9:49:17 AM

http://www.it-ebooks.info