beautypg.com

Operation at the local site, Restoring an sql server database to the local site, Operation at the remote site – HP XP Array Manager Software User Manual

Page 331

background image

4.

Confirm that data has been correctly backed up to tape.

To confirm that backup information with the date of the backup from the primary volume to the
secondary volume exists, execute

drmtapecat

on the backup server.

BKServer > drmtapecat

BACKUP-ID BACKUP-OBJECT SNAPSHOT TIME EXPIRATION TIME BACKUP-MEDIA

0000000002 MSSQL 2004/08/05 10:00:00 2004/11/05 10:00:00 MEDIA1

BKServer >

5.

Clear the cache of the secondary volume.

After the tape backup operation finishes, 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.

BKServer > EX_DRM_CACHE_PURGE Operation_A

Operation at the local site

Resynchronize the copy group.

To resynchronize the copy group, execute

EX_DRM_RESYNC

on the database server.

DBServer > EX_DRM_RESYNC Operation_A

Restoring an SQL Server database to the local site

The example provided below explains the operation used to restore an SQL Server database to the
local site if the local site is normally active and is free from any problem. Procedures at the local site
and remote site are explained separately.

Operation at the remote site

1.

Split the Continuous Access Software pair (usual operation is in the pair status).

BKServer > pairsplit -g TC01 -d SQL11 -rw

BKServer >

2.

Check the backup ID of the backup data you want to use for restoration.

To check the backup ID, execute the

drmtapecat

command on the backup server.

BKServer >drmtapecat

BACKUP-ID ORIGINAL-ID BACKUP-OBJECT INSTANCE SNAPSHOT TIME EXPIRATION TIME BACKUP-MEDIA

0000000002 0000000001 MSSQL default 2004/08/05 10:00:00 2004/11/05 10:00:00 -

:

:

BKServer >

Application Agent CLI User Guide

331