HP StorageWorks P9000 Replication Manager Software 7.1 CLI User Guide (TB584-96026, May 2011)

4. Check that correct data is restored from the tape to the secondary volume.
To check that backup information with the date of the backup from the primary volume to the
secondary volume is restored on the backup server, execute the drmsqlcat command on the
backup server.
BKServer > drmsqlcat default
INSTANCE: default
BACKUP-ID: 0000000003 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 BC01,SQL01
- - - - - - - BC01,SQL01
T UserDB1 TRANSACT G:\UserDB1_Log.LDF G: - Harddisk1 BC01,SQL01
BKServer >
5. Mount the restored volume by using the disk management function.
Mount is performed to the G: drive.
6. Restart SQL Server.
7. Create a backup ID file.
To create a backup ID file, execute EX_DRM_BACKUPID_SET with a backup ID.
BKServer > EX_DRM_BACKUPID_SET Operation_A -backup_id 0000000003
8. Perform restore operation in the remote site.
Since the operation here does not include copy group resynchronization, specify the -no_resync
option.
BKServer > EX_DRM_SQL_RESTORE Operation_A -no_resync -nochk_host
9. Recover the SQL Server database.
To recover the SQL Server database, execute the drmsqlrecover or drmsqlrecovertool
command on the backup server at the local site.
10. If a Business Copy pair is deployed in the remote site, continue operation in the remote site by,
for example, placing a backup into the pair volume.
Recovering data from the remote site to the local site
Assuming that you have restored the SQL Server database onto the remote site and then the local site
has recovered from the problem, the procedure below explains how to recover the restored database
from the remote site onto the local site.
Operation at the local site
1. If SQL Server is running on the database server, stop SQL Server.
2. Use a disk management function to unmount the volume mounted by using the disk management
function.
Operation at the remote site
1. Stop SQL Server.
CLI User Guide 333