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

3. Restore data from its backup tape to the secondary volume.
To restore data, execute EX_DRM_TAPE_RESTORE on the backup server.
BKServer > EX_DRM_TAPE_RESTORE Operation_A -backup_id 0000000002
When restore is performed, information about the restore operation is registered in the backup
catalog on the backup server with new backup ID
0000000003 .
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 SI01,SQL01
- - - - - - - SI01,SQL01
T UserDB1 TRANSACT G:\UserDB1_Log.LDF G: - Harddisk1 SI01,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 for SQL Server databases 334