HP XP7 Replication Manager Application Agent CLI User Guide (TK981-96015, May 2014)

ManualsBrandsHP ManualsSoftwareHP XP Array Manager Enterprise Media Kit

331

332

333

334

335

336

337

338

339

340

3. Check that the import operation has been performed correctly.

To confirm that backup information with the date of the backup from the primary volume to the

secondary volume has been imported to the database server, execute the drmsqlcat command

on the database server.

DBServer > drmsqlcat default

INSTANCE: default

BACKUP-ID: 0000000002 BACKUP-MODE: ONLINE INSTANCE: default ORIGINAL-ID: 0000000001

START-TIME: 2004/08/05 10:00:00 END-TIME: 2004/08/05 10:03:00 HOSTNAME: DBServer

T DB OBJECT FILE FS DG DEVICE COPY-GROUP

M UserDB1 METAFILE G:\META_0000000005.dmp - - - -

D UserDB1 DATAFILE G:\UserDB1_Data.MDF G: - Harddisk1 SI01,SQL01

- - - - - - - SI01,SQL01

T UserDB1 TRANSACT G:\UserDB1_Log.LDF G: - Harddisk1 SI01,SQL01

DBServer >

4. Restore the data from the secondary volume to the primary volume.

Restore the data by resynchronizing the primary and secondary volumes. To restore the data,

execute EX_DRM_SQL_RESTORE on the database server.

DBServer > EX_DRM_SQL_RESTORE Operation_A -resync

5. Recover the SQL Server database.

To recover the SQL Server database, execute the drmsqlrecover or drmsqlrecovertool

command on the database server at the local site.

6. 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 a remote site

The example provided below explains the operation used to restore an SQL Server database in a

remote site if the local site has encountered a problem.

Operation at the remote site

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

Change the pair status from PAIR to SMPL.

BKServer > pairsplit -g TC01 -d SQL11 -S

BKServer >

2. Check the backup ID of the backup 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 333