HP Serveur lame HP ProLiant BL465c Gen8 User Manual

Page 295

Advertising
background image

Using the drmsqlrecover command to recover an SQL Server database

The

drmsqlrecover

command is useful for recovering particular databases and recovering multiple

volumes at once.

To use the drmsqlrecover command to recover an SQL server database:

Specify an instance name to execute the

drmsqlrecover

command.

The following command illustrates execution of the

drmsqlrecover

command to recover an

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 has the loading status and is not accessible. Note that the

-undo

option cannot be used unless the UNDO file storage directory has been set using the

drmsqlinit

command.

Using the drmsqlrecovertool dialog box to recover an SQL Server database

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

295

Advertising