HP 3PAR Recovery Manager 4.5.0 Software for Microsoft SQL Server User Guide

Removing a Virtual Copy.........................................................................................................52
Viewing Event Message Descriptions.........................................................................................52
Viewing Online Help..............................................................................................................53
6 Using the Recovery Manager CLI................................................................54
HP 3PAR Recovery Manager for Microsoft SQL Server Command Line Interface (CLI).......................54
Recovery Manager Commands................................................................................................55
HpRmCli Sql analyze.........................................................................................................55
HpRmCli Sql backup..........................................................................................................56
HpRmCli Sql create............................................................................................................57
HpRmCli Sql deletebackup..................................................................................................60
HpRmCli Sql display..........................................................................................................61
HpRmCli Sql listbackup.......................................................................................................62
HpRmCli Sql mount............................................................................................................63
HpRmCli Sql policy............................................................................................................65
HpRmCli Sql portconfig......................................................................................................67
HpRmCli Sql remove..........................................................................................................68
HpRmCli Sql report............................................................................................................68
HpRmCli Sql repository.......................................................................................................69
HpRmCli Sql rescan...........................................................................................................69
HpRmCli Sql restore...........................................................................................................70
HpRmCli Sql setvc..............................................................................................................73
HpRmCli Sql timeconfig......................................................................................................75
HpRmCli Sql unmount.........................................................................................................76
Running Recovery Manager as a Scheduled Job.........................................................................76
Scheduling an Automated Task in Windows...............................................................................76
7 Recovery for Microsoft SQL Server..............................................................78
Microsoft SQL Server Recovery Models......................................................................................78
Recovering Data with HP 3PAR Recovery Manager.....................................................................78
Preparing for the Recovery Process............................................................................................78
Recovering from Logical Errors with Point-in-Time Recovery............................................................79
Restoring an SQL Instance in an Failover Cluster Environment Using File Copy Restore.................79
Restoring a Volume in Failover Cluster Environment Using Volume Restore..................................79
Recovering All Data with Point-of-Failure Recovery.......................................................................80
Determining Whether You Can Perform a Point-of-Failure Recovery...........................................80
Performing a Point-of-Failure Recovery...................................................................................80
Recovering Data with Auto-Restore............................................................................................81
Performing a File Copy Restore............................................................................................82
Performing a Volume Restore...............................................................................................84
Performing volume and file copy restore for availability databases............................................84
8 Coexistence of HP 3PAR Recovery Manager for SQL and HP 3PAR Recovery
Manager for Exchange................................................................................86
Prerequisites...........................................................................................................................86
9 Using HP 3PAR Peer Motion Manager Software with Recovery Manager.........87
10 Using HP 3PAR CLX with Recovery Manager..............................................88
11 Remote Copy for Recovery Manager..........................................................90
Overview..............................................................................................................................90
How Remote Copy Works........................................................................................................90
Setting Up Remote Copy..........................................................................................................91
Support for Remote Copy Modes and Policies........................................................................92
Support for GeoCluster for Microsoft Windows......................................................................92
Setting Up Remote Copy Volume Groups...................................................................................92
Setting Up a Remote Copy Volume Group for Databases........................................................92
Contents 5