HP Serveur lame HP ProLiant BL465c Gen8 - Manual (Page 333)

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