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
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