HP XP Array Manager Software - Manual (Page 332)

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 confirm that backup information with the date of the backup from the primary volume to the
secondary volume has been restored to 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 F:\MSSQL\meta\0000000131_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. Export the backup information to temporary files.
Before you can restore an SQL Server database from the secondary volume to the primary volume,
you need to copy backup information on the tape-to-secondary-volume restore operation to the
file server.
BKServer > EX_DRM_DB_EXPORT Operation_A
Operation at the local site
1. In the local site database server, obtain the temporary files.
To receive the temporary files collectively from the backup server, execute EX_DRM_FTP_GET
on the database server. The temporary files are stored in the temporary directory for extended
commands, on the database server.
DBServer > EX_DRM_FTP_GET Operation_A -server BKServer -user admin -password password
2. Import the temporary files, which were transmitted from the backup server, into the backup catalog
on the database server.
To import the temporary files, which were transmitted from the backup server, into the backup
catalog on the database server, execute
EX_DRM_DB_IMPORT on the database server.
DBServer >EX_DRM_DB_IMPORT Operation_A
Operation for SQL Server databases 332