HP XP Command View Advanced Edition Software User Manual
Page 381
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 “
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, “
Application Agent CLI User Guide
381