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

8. Check the execution results of the restoration from the tape to the secondary volume.
To confirm that the restoration finished successfully, execute the drmsqlcat command on the
backup server at the remote site.
PROMPT> drmsqlcat default -template
INSTANCE: default
BACKUP-ID: 0000000003 BACKUP-MODE: ONLINE INSTANCE: default ORIGINAL-ID: 0000000001
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
BC01,sql01
- - - - - - -
BC01,sql01
T UserDB1 TRANSACT O:\UserDB1_Log.LDF O: - Harddisk4
BC01,sql01
- - - - - - -
BC01,sql01
PROMPT>
9. Export the backup catalog to a temporary file.
To perform restoration from a secondary volume to a primary volume, you must copy the backup
catalog that contains information pertaining to the operations performed during the restoration
to the secondary volume. Copy this backup catalog to the database server on the remote site.
To export the backup information to the FTP root folder, execute the drmdbexport command.
The following assumes that the FTP root folder is C:\FTP_ROOT, and that the backup information
is exported to C:\FTP_ROOT\EX-FILE1.drm.
PROMPT> drmdbexport 0000000003 -f C:\FTP_ROOT\EX-FILE1.drm
KAVX0001-I The drmdbexport command will now start.
KAVX0002-I The drmdbexport command will now end.
10. From the database server, obtain the temporary file that was exported on the backup server.
Obtain the temporary file C:\FTP_ROOT\EX-FILE1.drm, which was exported on the backup
server, from the database server at the remote site. Use the ftp (file transfer protocol) command
to obtain the temporary file C:\FTP_ROOT\EX-FILE1.drm (created in step 9) to the database
server. The temporary file will be stored in the current directory. The following assumes that the
current directory is C:\.
PROMPT> ftp backup-server-name
ftp> Username: (Enter the login name)
ftp> password: (Enter the password)
ftp> binary
ftp> get EX-FILE1.drm
ftp> quit
PROMPT>
Operation for SQL Server databases372