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

# 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.

During command execution, from another computer such as an application server, you should not

connect to the database that was restored. If another server connects to the database during command

execution, the command might fail.

Arguments

instance-name

Basic commands172