HP P9000 Replication Manager Software 7.3.1-00 Application Agent CLI Reference Guide
Specify this option if you want to display the log sequence number CHECKPOINT-LSN of the log
record that is used as the starting point of a recovery when restoring a backup file of the data file
indicated by the DATAFILE of OBJECT and the full backup time FULL-BACKUP-TIME.
Note
When specifying on the command line a file name or directory name containing space characters
for the -target or -f option, you must enclose the file name in double quotation marks (").
Note that enclosing with double quotation marks is not necessary for target paths specified in batch
definition files.
Return Values
0: Normal termination
Any value other than 0: Termination with an error
Examples
• In this example, the command is used to display information about the SQL Server database spe-
cified in instance SQL1:
PROMPT> drmsqlcat SQL1
INSTANCE: SQL1
BACKUP-ID: 0000000001 BACKUP-MODE: ONLINE INSTANCE: SQL1 ORIGINAL-ID: 0000000001
START-TIME: 2002/06/01 10:00:00 END-TIME: 2002/06/01 10:03:00 HOSTNAME: DB_SVR1
T DB OBJECT FILE FS DG DEVICE COPY-GROUP
M DB1 METAFILE C:\METADIR\Meta1 C: - - -
D DB1 DATAFILE D:\SQL\data1.mdf D: - Harddisk2 VG02,dev02
- - - - - - - VG02,dev02
T DB1 TRANSACT D:\SQL\tlog1.ldf D: - Harddisk2 VG02,dev02
- - - - - - - VG02,dev02
M DB2 METAFILE C:\METADIR\Meta2 C: - - -
D DB1 DATAFILE D:\SQL\data2.mdf D: - Harddisk2 VG02,dev02
- - - - - - - VG02,dev02
T DB1 TRANSACT D:\SQL\tlog2.ldf D: - Harddisk2 VG02,dev02
- - - - - - - VG02,dev02
• In this example, the command is used to display two generations of backup information, in the
long format, about the SQL Server database specified in instance SQL1:
PROMPT> drmsqlcat SQL1 -l
INSTANCE: SQL1
BACKUP-ID: 0000000001 BACKUP-MODE: ONLINE INSTANCE: SQL1 ORIGINAL-ID: 0000000001
START-TIME: 2002/06/01 10:00:00 END-TIME: 2002/06/01 10:03:00 HOSTNAME: DB_SVR1
T DB OBJECT FILE FS FSTYPE DG LVM-DEVICE
DEVICE COPY-GROUP PORT# TID# LUN# MU# LDEV# P/S SERIAL#
M DB1 METAFILE C:\METADIR\Meta1 C: NTFS -
\\?\Volume{df66a5b0-5583-12d5-a410-806d6172696f}\
Harddisk1 VG11,dev01 CLI-A 2 10 0 10010 P 15044
D DB1 DATAFILE D:\SQL\data1.mdf D: NTFS -
\\?\Volume{df67a5b0-5583-11d5-a410-806d6172696f}\
Harddisk2 VG12,dev02 CLI-A 2 20 0 10020 P 15044
- - - - - - - -
- VG12,dev02 CLI-A 2 21 0 10021 S 15044
T DB1 TRANSACT D:\SQL\tlog1.ldf D: NTFS -
\\?\Volume{df67a5b0-5583-11d5-a410-806d6172696f}\
Harddisk2 VG12,dev02 CLI-A 2 20 0 10020 P 15044
- - - - - - - -
- VG12,dev02 CLI-A 2 21 0 10021 S 15044
M DB2 METAFILE C:\METADIR\Meta2 C: NTFS -
\\?\Volume{df66a5b0-5583-12d5-a410-806d6172696f}\
Harddisk1 VG11,dev01 CLI-A 2 10 0 10010 P 15044
Basic commands154