Backing up an sql server database – HP Serveur lame HP ProLiant BL465c Gen8 User Manual

Page 301

Advertising
background image

Resynchronize the copy group.

1.

For multi-generation operations, check the copy group to be used next.

To check the copy group to be used next, execute the

drmsqlcat

command on the backup

server.

If the copy group is not locked, the least recently backed up copy group is overwritten. You can
execute the

drmcgctl

command to check the lock status of a copy group.

2.

Clear the cache of the secondary volume.

Before backing up SQL Server, clear the system cache on the backup server.

To clear the system cache, on the backup server, execute

EX_DRM_CACHE_PURGE

to mount and

then unmount the secondary volume.

Clear the cache of the secondary volume which belongs to copy groups

VG01,vol11

and

VG01,vol12

. To specify multiple copy group names, you can create a copy-group list file ahead

of time, and simply specify the file. In this example, copy groups

VG01,vol11

and

VG01,vol12

are defined in the copy-group list file

CGLIST.txt

.

BKServer > EX_DRM_CACHE_PURGE Operation_A -cg_file C:\temp\CGLIST.txt

3.

Resynchronize the copy group.

Execute

EX_DRM_RESYNC

on the database server to resynchronize the copy groups. If there is

a big difference between the primary volume data and the secondary volume data when data
is backed up from the primary volume to the secondary volume, the backup might take a while.
You can facilitate backup processing by resynchronizing the copy group in advance.

DBServer > EX_DRM_RESYNC Operation_A -cg_file C:\temp\CGLIST.txt

-copy_size 7

Backing up an SQL Server database

To back up an SQL Server database:

1.

Back up the SQL Server database from the primary volume to the secondary volume.

Perform an online backup of the SQL Server database. To perform the backup, execute

EX_DRM_SQL_BACKUP

with the operation ID

Operation_A

.

When backing up all databases, including the system databases (master, model, and msdb),
specify the

-system

option for the

EX_DRM_SQL_BACKUP

parameter (if the

-system

option

is not specified, only user databases will be backed up).

Note that when backup is performed for all databases, including system databases,

TARGET_NAME

, in the operation definition file, must be blank.

DBServer > EX_DRM_SQL_BACKUP Operation_A -system

2.

Check that backup was performed properly.

To check that backup information exists for the date that backup was performed from the primary
volume to the secondary volume, execute the

drmsqlcat

command on the database server.

Application Agent CLI User Guide

301

Advertising