HP Serveur lame HP ProLiant BL465c Gen8 User Manual

Page 293

Advertising
background image

Figure 83 Procedure for backing up an SQL Server database to the secondary volume

Figure 84 Procedure for restoring an SQL Server database to the primary volume

Backing up an SQL Server database to a secondary volume

This section provides an example of performing an online backup of an SQL Server database between
volumes.

To back up the SQL Server database:

1.

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 VG01,vol01 -copy_size 7

2.

Back up the SQL Server database onto the secondary volume.

Execute

EX_DRM_SQL_BACKUP

to perform an online backup of the SQL Server database. Specify

the operation ID

Operation_A

as the argument.

DBServer > EX_DRM_SQL_BACKUP Operation_A -system

Application Agent CLI User Guide

293

Advertising