HP 3PAR Recovery Manager Software for Microsoft SQL Server Licenses - Manual (Page 5)

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