HP XP Command View Advanced Edition Software - Manual (Page 303)

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 303