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

- - - 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 ]
Description
The drmsqldisplay command does the following:
1. Displays the resource information of the SQL Server database on the server on which the command
was executed.
2. Displays resource information pertaining to optional instances for the system on which the com-
mand was executed.
3. Updates the SQL Server database information of the dictionary map files. Execute this command
before performing a backup.
The items displayed in 1 and 2 are shown in the table below.
Table 40 Items displayed by the drmsqldisplay command
MeaningDisplayed item
The name of the SQL server instanceINSTANCE
Application Agent CLI Reference Guide 161