HP P9000 Replication Manager Software 7.4.1-00 Release Notes (TB584-96068, April 2013)

Requirements
To use the Application Agent CLI in an SQL Server AlwaysOn Availability Groups configuration, you
must fulfill the requirements described in the Application Agent CLI manual in addition to the following
requirements.
• The version of Application Agent is 7.3.0-00 or later.
• The database software is SQL Server 2012.
• The version of the operating system on each server is within the range supported by Application
Agent.
• A SQL Server 2012 system database is installed on the primary database server, the secondary
database server, and the secondary server.
• A copy group is being used for pair management between the primary database server and the
backup server.
• A copy group is being used for pair management between the primary database server and the
secondary database server.
• A copy group is being used for pair management between the primary database server and the
secondary server.
• The drmsqlinit command has been executed on the primary database server, the secondary
database server, and the secondary server to register SQL Server parameters.
Operating procedure
This section describes the operating procedure for a SQL Server 2012 AlwaysOn Availability Group
configuration. The description uses the following names:
SQL Server instance: instA
User database: USER_A
Build a database on the secondary database server by using a backup
This section describes the procedure for restoring and recovering the data for a user database on the
secondary database server. (This procedure corresponds to step 1.)
1. Refresh the dictionary map file on the primary database server.
PROMPT > drmsqldisplay -refresh
PROMPT >
2. Back up the user database to a secondary volume.
Back up the user database on the primary database server. On the primary database server,
execute the drmsqlbackup command by using the -target option or -f option to specify the
user database.
PROMPT > drmsqlbackup instA -target USER_A
PROMPT >
When this command is executed, backup information is registered in the backup catalog of the
primary database server under a new backup ID (the next sequential unused ID number). In this
example, the new backup ID is 0000000001.
3. Back up the transaction logs of the user database.
To back up the transaction logs, on the primary database server, execute the drmsqllogbackup
command.
PROMPT > drmsqllogbackup instA
PROMPT >
Backup and restore management in a SQL Server 2012 AlwaysOn Availability Group configuration 9