Manualshelf

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

ManualsBrandsHP ManualsSoftwareHP Command View XP Advanced Edition Enterprise Media Kit
6789101112131415
2. If the user database of the secondary server (USER_A) is attached, detach it.
3. Prepare
• Stop the instance of the SQL Server.
• Unmount the file system of the secondary volume.
• Take the secondary volume disk offline.
4. Refresh the dictionary map file on the primary database server.
PROMPT > drmsqldisplay -refresh
PROMPT >
5. Back up the user database to the 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 >
6. 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.
7. Export the backup information to a temporary file.
Information about backup operations from primary volumes to secondary volumes must be copied
to the secondary 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 >
8. Transfer data to the secondary server.
Using a method of your choice, transfer the following files to the secondary 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
server.
9. Start an instance of SQL Server on the secondary server.
• Bring the secondary volume disk online.
• Mount the file system of the secondary volume.
• Start an instance of SQL Server.
12 Backup and restore management in a SQL Server 2012 AlwaysOn Availability Group configuration