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

ManualsBrandsHP ManualsSoftwareHP XP P9000 Command View Advanced Edition Software

171

172

173

174

175

176

177

178

179

180

[userDB2]

C:\LogBackup\userDB2_20021106010101_0001.bk

C:\LogBackup\userDB2_20021106050101_0002.bk

C:\LogBackup\userDB2_20021106090101_0003.bk

• In this example, the command is used to delete the backups of the transaction log backup files

with backup ID 0000000020 and with a log backup ID from 0001 to 0003:

PROMPT> drmsqllogbackup 0000000021 -d -s 0001 -e 0003

• In this example, the command is used to display information on the backups of the transaction log

backup files when two databases in the instance default have been backed up at different times

with different backup IDs.

Creating a transaction log target definition file:

Backup ID for the database userDB1: 0000000002

Backup ID for the database userDB2: 0000000003

PROMPT> drmsqllogbackup DEFAULT -v

# ORIGINAL-ID:0000000002 BACKUP-ID:0000000002 --> This line is handled as a comment line.

[userDB1]

C:\LogBackup\userDB1_20021106010101_0001.bk

C:\LogBackup\userDB1_20021106050101_0002.bk

C:\LogBackup\userDB1_20021106090101_0003.bk

# ORIGINAL-ID:0000000003 BACKUP-ID:0000000003 -> This line is handled as a comment line.

[userDB2]

C:\LogBackup\userDB2_20021106010101_0001.bk

C:\LogBackup\userDB2_20021106050101_0002.bk

C:\LogBackup\userDB2_20021106090101_0003.bk

PROMPT>

In this example, the command is used to list information for the backup IDs for the instance:

PROMPT> drmsqllogbackup DEFAULT -v BACKUP-ID

ORIGINAL-ID BACKUP-ID DB

0000000002 0000000002 userDB1

0000000003 0000000003 userDB2

PROMPT>

• In this example, the command is used to list information for the backup IDs when multiple databases

have been backed up at one time for the instance default.

PROMPT> drmsqllogbackup DEFAULT -v BACKUP-ID

ORIGINAL-ID BACKUP-ID DB

0000000002 0000000002 userDB1,userDB2 -->

Displays comma-separated information.

0000000003 0000000003 userDB2

PROMPT>

• In this example, the command is used to display the backup information of the transaction log

obtained with the -no_cat option:

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

CLI Reference Guide 171