beautypg.com

HP XP Array Manager Software User Manual

Page 341

background image

7.

Recover the SQL Server database.

To recover the SQL Server database, execute the

drmsqlrecover

or

drmsqlrecovertool

command on the database server at the local site.

The following command illustrates execution of the

drmsqlrecover

command to recover the

SQL Server database:

hostB > drmsqlrecover DEFAULT

KAVX0001-I The drmsqlrecover command will now start.

KAVX0002-I The drmsqlrecover command will now end.

hostB >

The following command illustrates execution of the

drmsqlrecovertool

command to recover

the SQL Server database:

hostB > drmsqlrecovertool DEFAULT

hostB >

When the command is executed, the drmsqlrecovertool dialog box is displayed. For details about
the drmsqlrecovertool dialog box, see the description of the

drmsqlrecovertool

command

in the manual HP XP7 Replication Manager Application Agent CLI Reference Guide.

Performing restoration and recovery on a host other than the
backup host

This section explains by way of an example how to restore and recover SQL Server database data
from a host other than the host that was used to make the backup. This explanation assumes the system
configurations shown in the following figures. Operations are usually performed on database server
1, but when an error occurs on database server 1, the operations are switched to database server
2.

Application Agent CLI User Guide

341