7 recovery for microsoft sql server, 10 support and other resources, A server virtualization environments – HP 3PAR Recovery Manager Software for Microsoft SQL Server Licenses User Manual

Page 5: B troubleshooting c event messages

Advertising
background image

RMSql create.....................................................................................................................45
RMSql deletebackup..........................................................................................................47
RMSql display...................................................................................................................48
RMSql listbackup...............................................................................................................49
RMSql mount.....................................................................................................................50
RMSql policy.....................................................................................................................52
RMSql portconfig...............................................................................................................54
RMSql remove...................................................................................................................55
RMSql report.....................................................................................................................55
RMSql repository...............................................................................................................56
RMSql rescan....................................................................................................................56
RMSql restore....................................................................................................................57
RMSql setvc......................................................................................................................60
RMSql timeconfig...............................................................................................................62
RMSql unmount.................................................................................................................63

Running Recovery Manager as a Scheduled Job.........................................................................63
Scheduling an Automated Task in Windows 2008......................................................................63

7 Recovery for Microsoft SQL Server..............................................................65

Microsoft SQL Server Recovery Models......................................................................................65
Recovering Data with HP 3PAR Recovery Manager.....................................................................65
Preparing for the Recovery Process............................................................................................65
Recovering from Logical Errors with Point-in-Time Recovery............................................................65

Restoring a SQL Instance in an MSCS Environment Using File Copy Restore...............................66
Restoring a Volume in an MSCS Environment Using Volume Restore..........................................66

Recovering All Data with Point-of-Failure Recovery.......................................................................66

Determining Whether You Can Perform a Point-of-Failure Recovery...........................................67
Performing a Point-of-Failure Recovery...................................................................................67

Recovering Data with Auto-Restore............................................................................................68

Performing a File Copy Restore............................................................................................69
Performing a Volume Restore...............................................................................................71

8 Using HP 3PAR Peer Motion Manager Software with Recovery Manager.........72
9 Remote Copy for Recovery Manager...........................................................73

Overview..............................................................................................................................73
How Remote Copy Works........................................................................................................73
Setting Up Remote Copy..........................................................................................................74

Support for Remote Copy Modes and Policies........................................................................74
Support for GeoCluster for Microsoft Windows......................................................................75

Setting Up Remote Copy Volume Groups...................................................................................75

Setting Up a Remote Copy Volume Group for Databases........................................................75
Setting Up a Remote Copy Volume Group for Instances..........................................................75

Recovering a SQL Database from a Remote Copy Backup Server..................................................76

10 Support and Other Resources...................................................................77

Related Documents.................................................................................................................77
Typographical Conventions......................................................................................................77
Advisories..............................................................................................................................78

A Server Virtualization Environments..............................................................79

VMWare and Microsoft Hyper-V Environments............................................................................79

B Troubleshooting........................................................................................80
C Event Messages.......................................................................................82

Contents

5

Advertising
This manual is related to the following products: