Backing up and restoring by using a tape device – HP Serveur lame HP ProLiant BL465c Gen8 User Manual

Page 296

Advertising
background image

To use the drmsqlrecovertool dialog box to recover an SQL Server database:

1.

Specify an instance name to execute the

drmsqlrecovertool

command.

DBServer > drmsqlrecovertool default

When you execute the command, the drmsqlrecovertool dialog box is displayed.

2.

Select a recovery destination database in Target database.

3.

Check the status of the database after recovery.

For Recovery mode, select the status of the recovered database.

Standby: Select this to perform recovery in the standby status (read-only and usable). Note that
you cannot select Standby unless the UNDO file storage directory is set using the

drmsqlinit

command.

Loading: Select this to perform recovery in the loading status.

Online: Select this to make the database fully accessible.

4.

Select whether to perform roll-forward.

To apply transaction logs (a roll-forward), select Yes for Roll forward?. If no transaction log is
displayed in Transaction log backup list, Roll forward? can be set to either Yes or No.

5.

Click the Recovery button.

If Online is selected for Recovery mode,

*

is appended to the file name displayed in Target

database, and recovery is complete.

Backing up and restoring by using a tape device

This section describes how to back up and restore data by using a tape device.

Operation for SQL Server databases

296

Advertising