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

Page 314: Logs

Advertising
background image

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.

DBServer > EX_DRM_SQL_BACKUP Operation_A

2.

Export the backup information to temporary files.

DBServer > EX_DRM_DB_EXPORT Operation_A

3.

Save the metafile created when backing up in the temporary folder.

DBServer > EX_DRM_SQLFILE_PACK Operation_A

4.

Transfer the metafile and the temporary file to the backup server.

DBServer > EX_DRM_FTP_PUT Operation_A -server BKServer -user admin -password password

5.

Import the temporary file transferred from the database server in the backup catalog of the backup
server.

BKServer > EX_DRM_DB_IMPORT Operation_A

6.

Expand the metafile transferred from the database server to the backup server.

BKServer > EX_DRM_SQLFILE_EXTRACT Operation_A

7.

Back up the data of the secondary volume to tape.

To back up, execute the

EX_DRM_TAPE_BACKUP

on the backup server. In this case, set the drive

characters of the secondary volume

E:

.

BKServer > EX_DRM_TAPE_BACKUP Operation_A -mount_pt E:

When backup is performed, information about related backup operations are registered in the
backup catalog.

Backing up transaction logs

This subsection explains how to back up the transaction logs at point B and point C.

Operation for SQL Server databases

314

Advertising