HP XP P9000 Replication Manager Software 7.6.0-00 Application Agent CLI Reference Guide

PROMPT> drmsqllogbackup -no_cat -v
# ORIGINAL-ID:- BACKUP-ID:-
[UserDB3]
C:\MSSQL\FLORA4\default\tlog\UserDB3_20040116163638_0001.bk
C:\MSSQL\FLORA4\default\tlog\UserDB3_20040116163640_0002.bk
# ORIGINAL-ID:- BACKUP-ID:-
[UserDB2]
C:\MSSQL\FLORA4\default\tlog\UserDB2_20040116163637_0001.bk
C:\MSSQL\FLORA4\default\tlog\UserDB2_20040116163640_0002.bk
# ORIGINAL-ID:- BACKUP-ID:-
[UserDB1]
C:\MSSQL\FLORA4\default\tlog\UserDB1_20040116163637_0001.bk
C:\MSSQL\FLORA4\default\tlog\UserDB1_20040116163640_0002.bk
• In this example, the command is used to create a transaction log target definition file (SQLTX-
LOG.txt) from the backup information of the transaction log:
PROMPT> drmsqllogbackup SQL1 -target DB1 -v > C:\temp\SQLTXLOG.txt
PROMPT>
• In this example, the command is used to obtain a backup of the transaction log when the data
files of the database are damaged:
PROMPT> drmsqllogbackup default -no_truncate
KAVX0001-I The drmsqllogbackup command will now start.
KAVX0002-I The drmsqllogbackup command will now end.
• In this example, this command is used to display the log backup information of the database:
PROMPT> drmsqllogbackup SQL2k8 -lsn
BACKUP-ID ORIGINAL-ID LOG-BACKUP-ID DB FILE
FIRST-LSN LAST-LSN LAST- FULL-BACKUP-TIME
0000000023 0000000023 0001 USERDB C:\SQL_LOG\LOG\USERDB_20091001122024_0001.bk
30000000021600001 30000000024100001 2009/10/01 12:20:24
0000000023 0000000023 0002 USERDB C:\SQL_LOG\LOG\USERDB_20091001122024_0002.bk
30000000024100001 30000000024100001 2009/10/01 12:20:24
- 0000000024 0001 USERDB C:\SQL_LOG\LOG\USERDB_20091001122024_0001.bk
30000000024100001 30000000024100010 2009/10/01 13:20:24
drmsqlrecover (Recovers restored SQL Server databases)
Format
drmsqlrecover instance-name
[ -target database-name | -f target-definition-file-name ]
[ -transact_log_list name-of-target-definition-file-for-transaction-logs ]
[ -undo | -loading ]
Description
The drmsqlrecover command recovers a database restored by the drmsqlrestore command.
This command applies transaction logs that are specified in a target definition file for transaction logs
or acquired during backup, and performs roll-forward recovery processing.
Application Agent CLI Reference Guide 177