HP XP7 Replication Manager Application Agent CLI User Guide (TK981-96015, May 2014)

3. Export the backup information to temporary files.
To restore data from the secondary volume to the primary volume, the backup information about
the restore operation from tape to the secondary volume needs to be copied to the database
server. To export the backup information to temporary files, execute EX_DRM_DB_EXPORT. These
temporary files are stored in the temporary folder for extended commands.
BKServer > EX_DRM_DB_EXPORT Operation_A
4. Back up the metafile created at the restoration to the temporary folder.
Back up the metafile created at the restoration to the temporary folder for extended commands
that is on the backup server, so that the metafile and temporary files can be transmitted collectively
to the database server. To back up the metafile, execute EX_DRM_SQLFILE_PACK on the backup
server. Note, however, that you do not need to execute this command if you did not register the
VDI metafile storage directory when executing the drmsqlinit command.
BKServer > EX_DRM_SQLFILE_PACK Operation_A
5. On the database server, receive the metafile and temporary files.
To receive the metafile and temporary files collectively from the backup server, execute
EX_DRM_FTP_GET on the database server. In this example, the user ID to log on to the FTP server
is admin and the login password is password. The metafile and temporary files are stored in
the temporary folder for extended commands, on the database server.
DBServer > EX_DRM_FTP_GET Operation_A -server BKServer -user admin -password password
6. 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
7. On the database server, deploy the metafile that was transmitted from the backup server.
To deploy the metafile transmitted from the backup server, execute EX_DRM_SQLFILE_EXTRACT
on the database server.
DBServer > EX_DRM_SQLFILE_EXTRACT Operation_A
8. 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
When EX_DRM_SQL_RESTORE is executed with the -undo option specified, restoration is
performed while the database is in the standby status, in which the database is read-only. If the
-undo option is omitted, after restoration, the status of the database changes to loading, and
the database cannot be viewed.
Also, be sure not to connect to SQL Server while executing EX_DRM_SQL_RESTORE.
Operation for SQL Server databases304