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

5. Export the backup information to temporary files.
Before you can restore an SQL Server database from the secondary volume to the primary volume,
you need to copy backup information on the tape-to-secondary-volume restore operation to the
file server.
BKServer > EX_DRM_DB_EXPORT Operation_A
Operation at the local site
1. In the local site database server, obtain the temporary files.
To receive the temporary files collectively from the backup server, execute EX_DRM_FTP_GET
on the database server. The temporary files are stored in the temporary directory for extended
commands, on the database server.
DBServer > EX_DRM_FTP_GET Operation_A -server BKServer -user admin -password password
2. Import the temporary files, which were transmitted from the backup server, into the backup catalog
on the database server.
To import the temporary files, which were transmitted from the backup server, into the backup
catalog on the database server, execute EX_DRM_DB_IMPORT on the database server.
DBServer >EX_DRM_DB_IMPORT Operation_A
3. Check that the import operation has been performed correctly.
To confirm that backup information with the date of the backup from the primary volume to the
secondary volume has been imported to the database server, execute the drmsqlcat command
on the database server.
DBServer > drmsqlcat default
INSTANCE: default
BACKUP-ID: 0000000002 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 G:\META_0000000005.dmp - - - -
D UserDB1 DATAFILE G:\UserDB1_Data.MDF G: - Harddisk1 BC01,SQL01
- - - - - - - BC01,SQL01
T UserDB1 TRANSACT G:\UserDB1_Log.LDF G: - Harddisk1 BC01,SQL01
DBServer >
4. 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 EX_DRM_SQL_RESTORE on the database server.
DBServer > EX_DRM_SQL_RESTORE Operation_A -resync
5. Recover the SQL Server database.
To recover the SQL Server database, execute the drmsqlrecover or drmsqlrecovertool
command on the database server at the local site.
CLI User Guide 331