HP StorageWorks P9000 Replication Manager Software 7.1 CLI User Guide (TB584-96026, May 2011)

Operation using SQL Server transaction logs
Backing up an SQL Server database entails either backing up all databases, or backing up transaction
log files.
When formulating a plan for backing up an SQL Server database, if the database is fairly large so
that the time required to perform backup is significant, or if the database is updated regularly, HP
recommends a combination of database backup and transaction log backup.
There are several precautions to keep in mind when backing up transaction logs. For details, see
“Precautions regarding backup of transaction logs” on page 280, “Precautions regarding sequences
of transaction logs” on page 281, or “Precautions regarding application of transaction logs” on page 283.
System configuration
The examples in this section assume the system configuration shown in the following figure.
Figure 89 System configuration for operations using the SQL Server transaction log
Application Agent allows you to use a cluster configuration for database servers. If a failover cluster
configuration is used for the database servers, the active server can be switched to the standby server
when a failure occurs on the active server.
The examples in this section assume the following conditions:
• The primary volume is NTFS-formatted.
CLI User Guide 309