HP Serveur lame HP ProLiant BL465c Gen8 User Manual

Page 379

Advertising
background image

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

Advertising