HP XP7 Replication Manager Application Agent CLI Reference Guide (TK981-96014, May 2014)

Table Of Contents
- - - 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
- - - - - -
- - - VG02.dev02
M DB2 METAFILE C:\METADIR\Meta2 - -
C: - - -
D DB1 DATAFILE D:\SQL\data2.mdf 259000000004000089 2009/10/01 10:01:00
D: - Harddisk2 VG02,dev02
- - - - - - -
- - VG02.dev02
T DB1 TRANSACT D:\SQL\tlog2.ldf - -
D: - Harddisk2 VG02,dev02
- - - - - -
- - - VG02.dev02
drmsqldisplay (Displays or updates information for an SQL Server database)
Formats
To display the information for the SQL Server database:
drmsqldisplay [ instance-name ]
[ -target database-name | -f target-definition-file-name ]
[ -transact_log ][ -datafile ]
[ -device device-file-name ][ -l ][ -v ][ -cf ]
To display information with linking for copy groups for both the local site and remote sites:
drmsqldisplay [ instance-name ]
[ -target database-name | -f target-definition-file-name ]
[ -transact_log ][ -datafile ]
[ -v ][ -remote ]
To update the information in the dictionary map files:
drmsqldisplay [instance-name ] -refresh [ -coremap ]
Basic commands158