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

4. Export the backup information at the local site to temporary files.
To back up data from the secondary volume to tape, copy the backup information to the backup
server. To export the backup information to temporary files, execute EX_DRM_DB_EXPORT. These
temporary files are stored in the temporary directory for extended commands, on the database
server.
hostB > EX_DRM_DB_EXPORT opid_SQL
5. Transmit the temporary files to the backup server at the local site.
Collectively transmit the temporary files from the database server to the backup server at the local
site. To transmit the temporary files, execute EX_DRM_FTP_PUT 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 temporary files are stored in the temporary directory for extended commands, on the backup
server.
hostB > EX_DRM_FTP_PUT opid_SQL -server hostA -user admin
-password password
6. Import the temporary files, which were transmitted from the database server, into the backup
catalog on the backup server at the local site.
To import the temporary files, execute EX_DRM_DB_IMPORT on the backup server.
hostA > EX_DRM_DB_IMPORT opid_SQL
7. Back up the data of the secondary volume to tape.
To back up the data, execute EX_DRM_TAPE_BACKUP on the backup server at the local site. In
this example, the drive letter of the secondary volume is assumed to be E:.
hostA > EX_DRM_TAPE_BACKUP opid_SQL -mount_pt E:
When this backup is executed, the backup information is registered, with a new backup ID of
0000000002, in the backup catalog.
Example of restoring an SQL Server database
This section provides an example of recovering an SQL Server database by restoring data backed
up to tape at a local site. This example describes restoration from a local site. For details about
performing restoration from a remote site, see “Restoring an SQL Server database in a cascade
configuration” on page 371. The example uses opid_SQL as the operation ID.
To restore an SQL Server database from tape in a multi-target configuration:
1. Check the backup ID of the backup you want to use for restoration.
To check the backup ID of the backup data to be used for restoration, execute the drmtapecat
command from the backup server of the local site.
hostA> drmtapecat
BACKUP-ID BACKUP-OBJECT SNAPSHOT TIME EXPIRATION TIME BACKUP-MEDIA
0000000002 MSSQL 2004/02/04 13:01:35 2004/05/04 13:01:35 MEDIA1
hostA>
Application Agent CLI User Guide 339