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

3. Use Explorer on the database server to allocate the temporary directory for extended commands
as a network drive.
In this case, C:\FTP_ROOT\script\Operation_A\BK is allocated to network drive X:.
4. On the backup server, set the permissions for the automatically generated temporary directory
for extended commands, so that users executing extended commands from the database server
can read and write to the directory.
Backing up an SQL Server database by using a file share
This subsection describes the procedure for backing up an SQL Server database by using a file share.
For details about operations for steps 1 through 4, or step 8 and beyond, see “Backing up an SQL
Server database to tape” on page 300.
The following conditions are assumed:
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. Delete unnecessary metafiles (those created during the previous backup) stored in the temporary
directory for extended commands that is on the backup server.
DBServer > del X:\*.dmp
7. Copy the temporary files to the temporary directory for extended commands that is on the backup
server.
DBServer > copy /y C:\Program Files\CVXPAE\DRM\script_work
\Operation_A\DB X:\
8. Execute EX_DRM_DB_IMPORT to import the temporary files copied from the database server,
into the backup catalog of the backup server.
9. Execute EX_DRM_SQLFILE_EXTRACT to deploy, on the backup server, the metafile transferred
from the database server.
10. When usual operation is in the pair status, execute EX_DRM_CACHE_PURGE to clear the cache
of the secondary volume.
11. When usual operation is in the pair status, execute EX_DRM_RESYNC to resynchronize the copy
group.
Example of restoring a database by using a file share
This subsection explains how to use file sharing to restore an SQL Server database to the backup
server. For details about the operations for steps 1 through 3, or step 7 and beyond, “Restoring an
SQL Server database from tape” on page 303.
Application Agent CLI User Guide 379