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

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 >
After executing the drmsqllogbackup command, be sure to avoid updating the user database
that was backed up.
4. Export the backup information to a temporary file.
Information about backup operations from primary volumes to secondary volumes must be copied
to the secondary database server. On the primary database server, execute the drmdbexport
command to export information about backup operations to a temporary file. In this example, the
name of the temporary file is C:\temp\EX-FILE1.drm.
PROMPT > drmdbexport 0000000001 -f C:\temp\EX-FILE1.drm
PROMPT >
5. Transfer data to the secondary database server.
Using a method of your choice, transfer the following files to the secondary database server:
• The exported temporary file
• VDI metafiles
• The backup files for the transaction logs
In this example, the exported temporary file is now C:\temp\EX-FILE1.drm on the secondary
database server.
6. Start an instance of SQL Server on the secondary database server.
• Bring the secondary volume disk online.
• Mount the file system of the secondary volume.
• Start an instance of SQL Server.
7. Import the temporary file transferred from the primary database server into the backup catalog
of the secondary database server.
Import the temporary file transferred from the primary database server (C:\temp\EX-FILE1.drm)
into the backup catalog of the secondary database server. To import the temporary file, on the
secondary database server, execute the drmdbimport command.
PROMPT > drmdbimport -f C:\temp\EX-FILE1.drm
PROMPT >
8. Verify that the file has been imported.
Verify that the import operation has finished normally. To do so, on the secondary database
server, execute the drmsqlcat command.
12 Backup and restore management in a SQL Server 2012 AlwaysOn Availability Group configuration