HP XP7 Replication Manager Application Agent CLI User Guide (TK981-96015, May 2014)

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 282, “Precautions regarding sequences
of transaction logs” on page 283, or “Precautions regarding application of transaction logs” on page 285.
System configuration
The examples in this section assume the system configuration shown in the following figure.
Figure 90 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.
Application Agent CLI User Guide 311