HP XP7 Replication Manager Application Agent CLI User Guide (TK981-96015, May 2014)

9. Recover the SQL Server database.
To recover the SQL Server database, execute the drmsqlrecover or drmsqlrecovertool
command.
The following shows an example of the drmsqlrecover command and drmsqlrecovertool
dialog box. For details on the drmsqlrecover command or the drmsqlrecovertool dialog box,
see the HP XP7 Replication Manager Application Agent CLI Reference Guide.
Recovering an SQL Server database with the drmsqlrecover command
The drmsqlrecover command is useful for recovering particular databases and recovering multiple
volumes at once.
• Specify an instance name to execute the drmsqlrecover command.
The following command illustrates execution of the drmsqlrecover command to recover the
SQL Server database:
DBServer > drmsqlrecover default
KAVX0001-I The drmsqlrecover command will now start.
KAVX0002-I The drmsqlrecover command will now end.
DBServer >
When you execute the drmsqlrecover command with an instance name specified, the database
becomes accessible, and the recovery is complete.
When you execute the drmsqlrecover command with the -undo option specified, the database
is recovered in the standby status (read-only and usable). When you execute with the -loading
option specified, the database becomes loading status and not accessible. Note that the -undo
option cannot be used unless the UNDO file storage directory has been set using the drmsqlinit
command.
Recovering an SQL Server database using the drmsqlrecovertool dialog box
The drmsqlrecovertool dialog box is useful for performing recovery and checking the status of
a database at the same time.
Application Agent CLI User Guide 305