HP StorageWorks P9000 Command View Advanced Edition Suite Software 7.0 Mainframe Agent Installation and Configuration Guide (TB581-96014, November 2010)

ManualsBrandsHP ManualsSoftwareHP XP Array Manager Enterprise Media Kit

171

172

173

174

175

176

177

178

179

180

Database recovery is complete when the database status becomes Online. After recovery with Online

checked, no transaction logs can be applied. Before bringing the database Online, make sure that

you apply all necessary transaction logs.

Roll forward?

Select whether or not to perform a roll-forward during recovery. If No is selected, the Transaction log

backup list becomes inactive. Recovery takes place without a roll forward, even when transaction log

backup files are displayed.

Add button

Choose this button to add a transaction log file to be applied. This button adds the selected file to the

files selected in Transaction log backup list. The files are sorted by name (not including file extensions

and path names) and added.

You cannot add the following files:

• Network files (files whose path begins with \\)

• Files that already exist in Transaction log backup list (files do not include extensions and paths).

Delete button

Choose this button to delete a transaction log backup file selected in Transaction log backup list. You

can select multiple backup files. All the selected files are deleted.

Recovery button

Choose this button to perform the roll-forward recovery on the database. Of the transaction log backup

files shown in Transaction log backup list, roll-forward recovery will be performed on files without an

asterisk (*) for the database selected in Target database, beginning from the top file. Roll-forward

recovery is not performed on the files when No is selected for Roll forward?.

When the recovery finishes, an asterisk (*) is added to the beginning of all the file names in Transaction

log backup list. If a recovery error occurs, the result is output to the message dialog box or

drm_output.log.

EXIT button

Closes the drmsqlrecovertool dialog box.

Message

Displays the progress of the command execution.

Return Values

None

Example

In this example, the command is used to recover the transaction log to the database for the instance

SQLIns:

PROMPT> drmsqlrecovertool SQLIns

drmsqlrestore (Restores SQL Server databases from backups to a primary volume)

Formats

To restore data by disk resynchronization:

Basic commands176