HP StorageWorks P9000 Replication Manager Software 7.1 CLI User Guide (TB584-96026, May 2011)

3. Check that backup was performed properly.
To check the backup information, execute drmsqlcat on the database server.
DBServer > drmsqlcat default
INSTANCE: default
BACKUP-ID: 0000000001 BACKUP-MODE: ONLINE INSTANCE: default ORIGINAL-ID: 0000000001
START-TIME: 2004/08/05 10:00:00 END-TIME: 2004/08/05 10:03:00 HOSTNAME: DBServer
T DB OBJECT FILE FS DG DEVICE
COPY-GROUP
M UserDB1 METAFILE F:\MSSQL\meta\0000000131_0000000005.dmp - - - -
D UserDB1 DATAFILE G:\UserDB1_Data.MDF G: - Harddisk1
Cnt Ac01,SQL11
- - - - - - -
Cnt Ac01,SQL11
T UserDB1 TRANSACT G:\UserDB1_Log.LDF G: - Harddisk1
Cnt Ac01,SQL11
DBServer >
4. Export the backup information to temporary files.
To perform backup from the secondary volume to tape, you need to copy information about the
backup operations from the primary volume to the secondary volume, to the backup server. To
export the information pertaining to the backup operations to temporary files, execute
EX_DRM_DB_EXPORT. The temporary files are stored in the temporary directory for extended
commands, on the database server.
DBServer > EX_DRM_DB_EXPORT Operation_A
5. Transfer the temporary files to the backup server.
Collectively transfer the temporary files from the database server to the backup server. The
temporary files are stored in the temporary directory for extended commands, on the backup
server.
DBServer > EX_DRM_FTP_PUT Operation_A -server BKServer -user admin -password password
Operation at the remote site
1. Import the temporary files that have been transferred from the local-site database server, to the
backup catalog on the backup server.
To import the temporary files, execute EX_DRM_DB_IMPORT on the backup server.
BKServer > EX_DRM_DB_IMPORT Operation_A
Operation for SQL Server databases328