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

11. Check the storage location of the metafile.
If you registered the VDI metafile storage directory when executing the drmsqlinit command,
the metafile (original-ID_database-ID.dmp) is stored in the following directory:
FTP_HOME_DIR-value\FTP_SUB_DIR-value\operation-ID\AP
\original-ID_database-ID.dmp
If you did not register the VDI metafile storage directory when executing the drmsqlinit
command, the metafile is stored in the drive containing data files and transaction log files.
12. Use a tape backup management software to back up the checked data files, transaction log files,
and metafile onto tape.
13. Execute the drmumount command to unmount the mount point mounted in step 10.
To restore an SQL Server database from a tape (where a tape backup management software that is
unable to link with Application Agent is used):
1. Execute the drmsqlcat command to identify the backup ID for the backup catalog to be restored.
2. Execute the drmmount command, and then restore the backup from tape to the storage location
checked in backup steps 10 and 11.
3. Execute EX_DRM_BACKUPID_SET with the backup ID specified to create a backup ID record
file.
4. Carry out the procedures following step 3 in “Restoring an SQL Server database from
tape” on page 301 to restore the backup from the secondary volume to the primary volume.
Backing up and restoring an SQL Server database by using a
file share
Usually, to transmit backup information between the database server and backup server, you can use
EX_DRM_FTP_PUT or EX_DRM_FTP_GET to perform FTP transfer. Instead of FTP, however, file sharing
can also be used to copy backup information between servers.
The following subsections describe examples of backing up or restoring an SQL Server database by
using a file share.
The examples in this section assume the system configuration shown in the following figure.
Operation for SQL Server databases376