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

- - - - - - - VG02,dev02
T DB1 TRANSACT D:\SQL\tlog2.ldf D: - Harddisk2 VG02,dev02
- - - - - - - VG02,dev02
• In this example, the command is used to display information about the SQL Server database spe-
cified by the instance SQL1 and management information for the backup catalog (when a backup
is not performed):
PROMPT> drmsqlcat SQL1 -v
VIRTUAL-SERVERNAME: DB_SVR1
DB-PATH: D:\Program Files\CVXPAE\DRM\db2
KAVX0024-E The specified backup data does not exist.
• In this example, the command is used to display the backup catalog beginning with SQL2-DR-
10.0:
PROMPT> drmsqlcat default -comment "SQL2-DR-10.01*"
INSTANCE: default
BACKUP-COMMENT: SQL2-DR-10.01-03:56-001
BACKUP-ID: 0000000010 BACKUP-MODE: ONLINE INSTANCE: default ORIGINAL-ID: 0000000010
START-TIME: 12.12.03 14:25:40 END-TIME: 12.12.03 14:25:41 HOSTNAME: flora4
T DB OBJECT FILE FS DG DEVICE COPY-GROUP
M UserDB1 METAFILE C:\ meta\0000000010_0000000005.dmp - - - -
D UserDB1 DATAFILE O:\UserDB1_Data.MDF
O: - Harddisk3 STD03,sqlstd022
- - - -
- - - STD03,sqlstd022
T UserDB1 TRANSACT O:\UserDB1_Log.LDF
O: - Harddisk3 STD03,sqlstd022
- - - -
- - - STD03,sqlstd022
• In this example, the command is used to display the template catalog:
PROMPT> drmsqlcat default -template
INSTANCE: default
BACKUP-ID: 0000000001 BACKUP-MODE: ONLINE INSTANCE: default ORIGINAL-ID: 0000000002
START-TIME: 04.02.04 13:01:35 END-TIME: 04.02.04 13:02:33 HOSTNAME: flora4
T DB OBJECT FILE FS DG DEVICE COPY-GROUP
M UserDB1 METAFILE O:\MSSQL\0000000002_0000000001.dmp - - - -
D UserDB1 DATAFILE O:\UserDB1_Data.MDF
O: - Harddisk4 SI01,sql01
- - - -
- - - SI01,sql01
T UserDB1 TRANSACT O:\UserDB1_Log.LDF
O: - Harddisk4 SI01,sql01
- - - -
- - - SI01,sql01
• In this example, the command is used to display the log sequence number and full backup time
of each database registered in the backup catalog:
PROMPT> drmsqlcat SQL1 -lsn
INSTANCE: SQL1
BACKUP-ID: 0000000001 BACKUP-MODE: ON-LINE INSTANCE: SQL1 ORIGINAL-ID: 0000000001
START-TIME: 2009/10/01 10:00:00 END-TIME: 2009/10/01 10:03:00 HOSTNAME: DB_SVR1
T DB OBJECT FILE CHECKPOINT-LSN FULL-BACKUP-TIME
FS DG DEVICE COPY-GROUP
M DB1 METAFILE C:\METADIR\Meta1 - -
C: - - -
D DB1 DATAFILE D:\SQL\data1.mdf 49000000018400037 2009/10/01 10:01:00
D: - Harddisk2 VG02,dev02
- - - - - -
- - - VG02.dev02
T DB1 TRANSACT D:\SQL\tlog1.ldf - -
D: - Harddisk2 VG02,dev02
- - - - - -
Basic commands160