HP P9000 Replication Manager Software 7.4.0-00 Release Notes (TB584-96062, December 2012)

1. Build a database on the secondary database server by using a backup.
This step includes the procedure for using a backup of the primary database server to build a
database on the secondary database server, which is required for an AlwaysOn Availability
Groups configuration.
2. Back up and restore the user database on the active node.
This step includes the procedure for normal backup and restoration operations by using Application
Agent, between the primary database server in the AlwaysOn Availability Groups configuration
and a backup server.
3. Build a database on the secondary server by using a backup.
This step includes the procedure for using a backup of the primary database server to build a
database on the secondary server. The secondary server can be used as, for example, the primary
database server in another AlwaysOn Availability Groups system.
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 >
Backup and restore management in a SQL Server 2012 AlwaysOn Availability Group configuration 11