beautypg.com

6 using the recovery manager cli, 7 recovery for microsoft sql server – HP 3PAR Recovery Manager Software User Manual

Page 5

background image

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