beautypg.com

HP XP Array Manager Software User Manual

Page 399

background image

4.

Back up the user database to the secondary volume.

On the database server (active server), execute the

drmsqlbackup

command with the

-target

or

-f

option specified.

To execute the

drmsqlbackup

command with the

-target

option specified:

PROMPT> drmsqlbackup instance-name -target user-database-name

To execute the

drmsqlbackup

command with the

-f

option specified:

PROMPT> drmsqlbackup instance-name -f target-definition-file-name

When the command is executed, backup information with a backup ID (the next unused ID) is
registered in the backup catalog on the database server (active server).

5.

Back up the user database transaction logs.

On the database server (active server), execute the

drmsqllogbackup

command.

PROMPT> drmsqllogbackup instance-name

After backing up the transaction logs, do not update the user database on the database server
(active server).

6.

Export the backup information to a file.

On the database server (active server), execute the

drmdbexport

command to export information

about the backup operations from the primary volume to the secondary volume.

PROMPT> drmdbexport backup-ID -f backup-information-file-name

7.

Transfer the files.

Transfer the following files to the secondary-use server (active server).

• Exported backup information file
• VDI metafile
• Transaction log backup file

8.

On the secondary-use server (active server), perform the following:

1.

Place the disk of the secondary volume online.

2.

Mount the file system on the secondary volume.

3.

Start the SQL Server instance.

9.

Import the backup information file.

On the secondary-use server (active server), execute the

drmdbimport

command to import the

backup information file exported from the active server to the backup catalog on the secondary-use
server (active server).

PROMPT> drmdbimport -f backup-information-file-name

Application Agent CLI User Guide

399