HP P6000 Continuous Access Software - Manual (Page 3)

Contents
1 Using HP StorageWorks DButil ............................................................. 7
Prerequisites ............................................................................................................................... 7
Supported software ..................................................................................................................... 7
Installing the utility ...................................................................................................................... 7
Running the utility ....................................................................................................................... 8
HP DButil commands ................................................................................................................... 8
DButil –pre .......................................................................................................................... 8
DButil –post ......................................................................................................................... 8
DButil –mfreeze .................................................................................................................... 8
DButil –mthaw ..................................................................................................................... 9
DButil –recover ..................................................................................................................... 9
DButil –restoresns ................................................................................................................. 9
DButil –setcred ..................................................................................................................... 9
Optional parameters and other considerations ............................................................................... 9
Named instances ................................................................................................................. 9
Database names that contain spaces .................................................................................... 10
Metadata files ................................................................................................................... 10
2 Creating snapshot backups using HP DButil ......................................... 11
Procedure ................................................................................................................................ 11
Determining which databases require backup ............................................................................... 11
Setting credentials .................................................................................................................... 11
Creating the HP DButil batch files ................................................................................................ 12
Single SQL Server database ................................................................................................ 12
Three SQL Server databases on a common set of volumes ....................................................... 12
Determining which volumes need to be replicated ......................................................................... 13
Single SQL Server database ................................................................................................ 13
Three SQL Server databases on a common set of volumes ....................................................... 13
Constructing HP Replication Solutions Manager jobs or Windows batch files .................................... 14
Sample HP Replication Solutions Manager jobs using templates .............................................. 14
Sample HP Replication Solutions Manager job ................................................................ 14
Sample HP Replication Solutions Manager snapshot job using replicate wizard ................... 15
Sample HP Replication Solutions Manager snapclone job using replicate wizard ................ 16
Sample HP Replication Solutions Manager mirrorclone creation using replicate wizard ........ 17
Sample XP disk array job using Windows batch file ........................................................ 20
Testing the process ............................................................................................................. 21
Backing up transaction logs ....................................................................................................... 21
3 SQL Server recovery using HP DButil .................................................. 23
Recovery approaches ................................................................................................................ 23
Volume replacement ........................................................................................................... 23
Selective file replacement .................................................................................................... 23
Applying transaction logs to a restored database .......................................................................... 24
Example recovery scenarios ....................................................................................................... 24
HP StorageWorks DButil user guide 3