Software Suite for Microsoft SQL Licenses User guide

Viewing Event Message Descriptions.........................................................................................41
7 Using the Recovery Manager CLI................................................................42
Recovery Manager for SQL Server Command Line Interface (CLI)..................................................42
Recovery Manager Commands................................................................................................42
RMSql analyze..................................................................................................................43
RMSql backup...................................................................................................................44
RMSql create.....................................................................................................................46
RMSql deletebackup..........................................................................................................49
RMSql display...................................................................................................................50
RMSql listbackup...............................................................................................................51
RMSql mount.....................................................................................................................52
RMSql policy.....................................................................................................................53
RMSql portconfig...............................................................................................................56
RMSql remove...................................................................................................................57
RMSql report.....................................................................................................................58
RMSql repository...............................................................................................................59
RMSql restore....................................................................................................................60
RMSql setvc......................................................................................................................63
RMSql timeconfig...............................................................................................................65
RMSql unmount.................................................................................................................66
Running Recovery Manager as a Scheduled Job.........................................................................66
Scheduling an Automated Task in Windows 2003......................................................................66
Scheduling an Automated Task in Windows 2008......................................................................67
8 Recovery for Microsoft SQL Server..............................................................68
Microsoft SQL Server Recovery Models......................................................................................68
Recovering Data with HP 3PAR Recovery Manager.....................................................................68
Preparing for the Recovery Process............................................................................................68
Recovering from Logical Errors with Point-in-Time Recovery............................................................68
Restoring a SQL Instance in an MSCS Environment Using File Copy Restore...............................69
Restoring a Volume in an MSCS Environment Using Volume Restore..........................................69
Recovering All Data with Point-of-Failure Recovery.......................................................................69
Determining Whether You Can Perform a Point-of-Failure Recovery...........................................70
Performing a Point-of-Failure Recovery...................................................................................70
9 Remote Copy for Recovery Manager...........................................................72
Overview..............................................................................................................................72
How Remote Copy Works........................................................................................................72
Setting Up Remote Copy..........................................................................................................73
Support for Remote Copy Modes and Policies........................................................................74
Support for GeoCluster for Microsoft Windows......................................................................74
Setting Up Remote Copy Volume Groups...................................................................................74
Setting Up a Remote Copy Volume Group for Databases........................................................74
Setting Up a Remote Copy Volume Group for Instances..........................................................75
Recovering a SQL Database from a Remote Copy Backup Server..................................................75
A Server Virtualization Environments..............................................................76
VMWare and Egenera............................................................................................................76
B Troubleshooting........................................................................................77
C Event Messages.......................................................................................79
Contents 5