Manualshelf

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

ManualsBrandsHP ManualsSoftwareHP XP Array Manager Enterprise Media Kit
321322323324325326327328329330
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 >
BKServer > pairsplit -g Cnt Ac01 -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 >
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
BC01,SQL01
- - - - - - -
BC01,SQL01
T UserDB1 TRANSACT G:\UserDB1_Log.LDF G: - Harddisk1
BC01,SQL01
BKServer >
Operation for SQL Server databases330