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

11. Import the temporary file into the backup catalog on the database server.
To import the temporary file C:\EX-FILE1.drm (transferred from the backup server in step 10)
into the backup catalog on the database server, execute the drmdbimport command on the
database server of the remote site.
PROMPT> drmdbimport -f C:\EX-FILE1.drm
KAVX0001-I The drmdbimport command will now start.
KAVX0418-I Backup information from the specified file was imported into the backup catalog.
Imported backup ID = 0000000002
KAVX0002-I The drmdbimport command will now end.
PROMPT>
At a restoration, backup information is registered in the backup catalog of the database server
under the new backup ID 0000000002. Also, since the fact that a restoration was performed
from tape to the secondary volume is reflected in the backup catalog, the backup ID 0000000001,
which was used to manage the status of the secondary volume before the update, is deleted from
the backup catalog on the database server.
12. Check the backup catalog for the copy group to be used for restoration.
Execute the drmsqlcat command on the database server at the remote site.
PROMPT> drmsqlcat default -template
INSTANCE: default
BACKUP-ID: 0000000002 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
BC12,sql01
- - - - - - -
BC12,sql01
T UserDB1 TRANSACT O:\UserDB1_Log.LDF O: - Harddisk4
BC12,sql01
- - - - - - -
BC12,sql01
13. On the remote site, mount the primary volume.
14. On the remote site, start the SQL Server service.
15. Restore the data from the secondary volume to the primary volume.
Restore the data by resynchronizing the primary and secondary volumes. To restore the data,
execute the drmsqlrestore command on the database server at the remote site. If you want
to execute the command with the template catalog backup ID specified, specify the -template
option.
PROMPT> drmsqlrestore 0000000003 -resync -template
KAVX0001-I The drmsqlrestore command will now start.
KAVX1316-I Performing restore pre-processing...
KAVX1000-I Logged on to the SQL Server system.
KAVX1300-I Restore processing will now start.
KAVX1000-I Logged on to the SQL Server system.
KAVX1301-I Restore processing has finished.
KAVX1318-I Performing restore post-processing..
KAVX1001-I Logged off from the SQL Server system.
KAVX0002-I The drmsqlrestore command will now end.
CLI User Guide 373