HP Serveur lame HP ProLiant BL465c Gen8 - Manual (Page 316)

4. Select Standby for Recovery mode and Yes for Roll forward?, and click the Recovery button.
The transaction log obtained at point B and point C is applied, and the database is restored to
the status at point C.
At this point, the status of the database after recovery changes based on the selection for Recovery
mode. Select Standby to perform recovery with the standby status (read-only and usable), Loading
to perform recovery with the loading status, or Online to perform recovery with full access to the
database.
If Online was selected, allowing full access to the database, any existing transaction logs can
no longer be applied. To apply multiple transaction logs in several separate batches, select either
Loading or Standby for Recovery mode. Note that Standby cannot be selected unless the UNDO
file storage directory has been set using the
drmsqlinit command.
After recovering databases in the standby status or loading status, open the drmsqlrecovertool
dialog box again, select Online for Recovery mode, and click the Recovery button to allow full
access.
Using the drmsqlrecover command to recover an SQL Server database (using a transaction
log list file)
When using the drmsqlrecover command to recover multiple databases, you can use a transaction
log list file to apply multiple transaction logs at once.
To perform recovery using a transaction log list file:
1. Create a list file for backed up transaction logs.
DBServer > drmsqllogbackup DEFAULT -v > c:\temp\SQLTXLOG.txt
A transaction log list file named SQLTXLOG.txt is created in the c:\temp directory. This file
contains the contents of the backed up transaction logs.
The following shows an example of a transaction log list file.
# ORIGINAL-ID:0000000080 BACKUP-ID:0000000080
[DB03]
l:\mssql\log\DB03_20040811115351_0001.bk
l:\mssql\log\DB03_20040811115431_0002.bk
# ORIGINAL-ID:0000000080 BACKUP-ID:0000000080
[DB02]
l:\mssql\log\DB02_20040811115351_0001.bk
l:\mssql\log\DB02_20040811115431_0002.bk
# ORIGINAL-ID:0000000080 BACKUP-ID:0000000080
[DB01]
l:\mssql\log\DB01_20040811115351_0001.bk
l:\mssql\log\DB01_20040811115431_0002.bk
2. Perform recovery by applying the transaction log batch.
To perform recovery by applying a transaction log list file, execute the drmsqlrecover command
with the -transact_log_list option specified.
DBServer > drmsqlrecover DEFAULT -transact_log_list c:\temp\SQLTXLOG.txt
Operation for SQL Server databases 316