HP XP P9000 Replication Manager Software 7.6.0-00 Application Agent CLI User Guide

To restore an SQL Server database on the backup server by using a file share:
1. Execute the drmtapecat command to check the backup ID of the backup data.
2. Execute EX_DRM_TAPE_RESTORE to restore the backed up data from tape to the secondary
volume.
3. Execute EX_DRM_DB_EXPORT to export the backup information to a temporary file.
4. Execute EX_DRM_SQLFILE_PACK to back up the SQL Server metafile created at the restoration
to the temporary folder.
5. Delete unnecessary metafiles (those created during the previous backup) stored in the temporary
directory for extended commands that is on the database server.
DBServer > del C:\Program
Files\CVXPAE\DRM\script_work\Operation_A\DB\*.dmp
6. Copy the temporary files to the temporary directory for extended commands that is on the database
server.
DBServer > copy /y X:\*.dmp C:\Program Files\CVXPAE\DRM\script_work\Operation_A\DB
7. Execute EX_DRM_DB_IMPORT to import the temporary files transferred from the backup server,
into the backup catalog of the database server.
8. Execute EX_DRM_SQLFILE_EXTRACT to deploy, on the database server, the SQL Server metafile
transferred from the backup server.
9. Execute EX_DRM_SQL_RESTORE to restore the secondary volume data to the primary volume.
Restoring data to an SQL Server instance that is different from
the backup source
If you are unable to specify the same SQL Server instance name for the restoration destination database
as the one specified as the backup source, you can restore (recover) the data to an SQL Server instance
other than the backup source.
System configuration
The figure below shows the system configuration for restoring data to a different SQL Server instance.
Operation for SQL Server databases380