HP Data Protector 6.2 software integration with HP 3PAR Storage System

32
• In cases where MS SQL is running in the MS cluster, put all involved disks in the maintenance
mode.
• Retrieve disk signature from all disks (use diskpart detail disk CLI)
• Unmount all involved disks and put them in offline mode.
• Remove all presentations from all virtual LUNs (un-export virtual LUNs) from all hosts.
• Promote all virtual copies to the parent LUN. Note that you have to promote the read-only (marked
with ro) virtual copy (see
Figure 29). Make sure that all promoted virtual copies are made in the
same backup session!
• Wait until data is copied to the parent LUN.
• Export all virtual LUNs to all hosts where they were presented before restore.
• On the application host, put all disks online.
• Remove read-only flag from the restored volume (use diskpart commands: select volume,
attr volume clear readonly)
• Change the disk signature for all disks back to its original value.
• Mount disks on the same mount point as they were mounted before restore.
• In cases where MS SQL is running in the MS cluster, take all disks out of maintenance mode.
• Resume the script.
Figure 29: Promote virtual copy to its parent
After the script is resumed, Data Protector will continue with the rest of the restore session. The
database will be left in the recovery mode so that transaction logs can be applied and database
restored to desired point-in-time.
The following is an example of a restore session using the manual restore option:
C:\Users\administrator.TIC>omnir -vss -barhost tpc193.tic.dp -session 2011/04/18
-35:tpc193 -tree "/SqlServerWriter(SQL Server 2008 R2:SQLWriter)/TPC193/DB1_3PAR
" -no_recovery -manual_restore SQL_man_restore.bat
[Normal] From: [e-mail] "" Time: 4/19/2011 1:18:07 AM
Restore session 2011/04/19-9 started.
[Normal] From: [e-mail] "MSVSSW" Time: 4/19/2011 1:14:59 AM
Performing Manual Restore.
[Normal] From: [e-mail] "MSVSSW" Time: 4/19/2011 1:14:59 AM
Loading Backup Metadata from VSS db.
[Normal] From: [e-mail] "MSVSSW" Time: 4/19/2011 1:14:59 AM
Connecting to Volume Shadow Copy Service.