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

Backing up and restoring using a backup management product
that cannot link with Application Agent
When using a tape backup management software that is unable to link with Application Agent, carry
out the following procedure to back up an SQL Server database to tape, or restore an SQL Server
database from tape. For details on operations from step 1 to step 6 in the backup procedure, see
“Backing up an SQL Server database to tape” on page 298.
For details on the restoration procedure, see “Restoring an SQL Server database from
tape” on page 301.
To back up an SQL Server database to tape (when using a tape backup management software that
is unable to link with Application Agent):
1. When usual operation is in the split state, execute EX_DRM_CACHE_PURGE to clear the secondary
volume cache.
2. When usual operation is in the split state, execute EX_DRM_RESYNC to resynchronize the copy
group.
3. Execute EX_DRM_SQL_BACKUP to back up the SQL Server database into the secondary volume.
4. Execute EX_DRM_DB_EXPORT to export the backup information into the temporary file.
5. Execute EX_DRM_SQLFILE_PACK to back up the SQL Server metafile created at the backup to
the temporary folder.
6. Execute EX_DRM_FTP_PUT to transfer the temporary files to the backup servers.
7. Execute EX_DRM_DB_IMPORT to import the temporary files transferred from the database server,
into the backup catalog of the backup server.
8. Execute EX_DRM_SQLFILE_EXTRACT to deploy, on the backup server, the SQL Server metafile
transferred from the database server.
9. Check the backup ID.
To check the backup ID, open the backup ID record file (operation-ID.bid) in the following
directory on the backup server:
FTP_HOME_DIR-value\FTP_SUB_DIR-value\operation-ID\BK\operation-ID.bid
10. Check the storage location of the data files and log files.
To check the location, execute the drmmount command using the backup ID checked in step 9
as the argument.
The command results show the mounted drive name. The mounted drive stores data files and
transaction log files for the SQL Server database. If necessary, execute the drmsqlcat command
to check the contents of the file to be backed up.
CLI User Guide 375