Document Outline

• HP 3PAR Recovery Manager 4.3.0 Software for Microsoft SQL Server
• Contents
• 1 Overview of Recovery Manager
  • System Requirements
    • Windows Server Requirements
      • Windows Server 2008
      • Windows Server 2008 R2
    • Additional System Requirements
  • Recovery Manager Requirements
  • Running Recovery Manager on a Japanese OS
  • Features Supported
  • Features Not Supported
  • Microsoft Volume Shadow Copy Service
  • Supported VSS Components
  • How HP 3PAR VSS Software Works with Microsoft SQL Server
  • Recovery Manager Layout
• 2 Installing and Uninstalling HP 3PAR Recovery Manager for SQL
  • Installing HP 3PAR Recovery Manager for SQL
  • Verifying the Installation
  • Understanding the Registry
  • Upgrading to Recovery Manager 4.3.0 for SQL
    • Upgrading the Production Server
    • Upgrading the Backup Server
    • Verifying the Upgrade
  • Uninstalling HP Recovery Manager for SQL
• 3 Configuring Recovery Manager
  • Configuring the SQL Database
  • Configuring Recovery Manager
    • Installation Location
    • Search Path
    • Changing the Recovery Manager TCP/IP Port
      • Changing a Production Server Port from the Backup Server
    • Configuring Recovery Manager Policies
    • Configuring Mount Functionality
    • Managing SQL Servers across Multiple Active Directory Domains
    • Grouping Volumes into Autonomic Groups
      • Domain Sets
      • Volume Sets
      • Host Sets
  • Testing SQL Connectivity
    • Troubleshooting SQL Connectivity
  • Configuring the Host Computer and the HP 3PAR Storage System
  • Formatting Partitions on a New HP 3PAR VLUN
• 4 Configuring Backup Software
  • Overview
  • Before You Begin
  • Setting Up Symantec NetBackup
  • Configuring HP Data Protector
    • Requirements
    • Setting Up the HP Data Protector Backup Specification
    • Setting Up HP Data Protector Cell Manager Access
  • Using Your Backup Software
    • Using Symantec NetBackup
    • Using HP Data Protector
• 5 Using the Recovery Manager GUI
  • Overview of the Recovery Manager GUI
    • Menu Bar
    • Node Tree Pane
    • Informational Pane
    • Status and Summary Information
  • Opening the Recovery Manager GUI
  • Closing the Recovery Manager GUI
  • Registering the Server
    • Updating Registration after Server Modification
  • Unregistering a SQL Server Instance
  • Setting the Recovery Manager Policy
    • How Recovery Manager Policies Work
      • Numeric-Based Policies
      • Expiration-Based Policies
      • Retention Time Restrictions
    • Setting Recovery Manager Policies
    • Modifying the Policy for a Virtual Copy
  • Configuring Email Notifications
  • Deleting Email Configurations
  • Creating Virtual Copies
    • How Virtual Copy Creation Works
    • Manually Creating a Virtual Copy
    • Creating Remote Virtual Copies
      • How Remote Virtual Copy Works
      • Manually Creating a Remote Virtual Copy
      • Displaying Remote Virtual Copies
    • Scheduling Automatic Virtual Copies
  • Automating Tasks
    • Scheduling Automated Tasks with Task Scheduler
    • Managing Automated Tasks with Task Manager
  • Prerequisites for Attach and Detach Operation
  • Mounting a Virtual Copy
  • Unmounting a Virtual Copy
  • Backing Up a Virtual Copy
    • Manually Creating Backups at the Instance or Database Level
    • Scheduling Automatic Backups of an Instance or Database
    • Creating a Backup of a Virtual Copy
  • Removing a Backup from the Repository
  • Restoring Instances, Databases, and Volumes
    • Restoring an Instance or Database with Volume Restore
    • Restoring an Instance or Database with File Copy Restore
    • Restoring an Instance or Database from a Backup
  • Analyzing and Synchronizing the Repository
  • Removing a Virtual Copy
  • Viewing Event Message Descriptions
  • Viewing Online Help
• 6 Using the Recovery Manager CLI
  • Recovery Manager for SQL Server Command Line Interface (CLI)
  • Recovery Manager Commands
    • RMSql analyze
    • RMSql backup
    • RMSql create
    • RMSql deletebackup
    • RMSql display
    • RMSql listbackup
    • RMSql mount
    • RMSql policy
    • RMSql portconfig
    • RMSql remove
    • RMSql report
    • RMSql repository
    • RMSql rescan
    • RMSql restore
    • RMSql setvc
    • RMSql timeconfig
    • RMSql unmount
  • Running Recovery Manager as a Scheduled Job
  • Scheduling an Automated Task in Windows 2008
• 7 Recovery for Microsoft SQL Server
  • Microsoft SQL Server Recovery Models
  • Recovering Data with HP 3PAR Recovery Manager
  • Preparing for the Recovery Process
  • Recovering from Logical Errors with Point-in-Time Recovery
    • Restoring a SQL Instance in an MSCS Environment Using File Copy Restore
    • Restoring a Volume in an MSCS Environment Using Volume Restore
  • Recovering All Data with Point-of-Failure Recovery
    • Determining Whether You Can Perform a Point-of-Failure Recovery
    • Performing a Point-of-Failure Recovery
  • Recovering Data with Auto-Restore
    • Performing a File Copy Restore
    • Performing a Volume Restore
• 8 Using HP 3PAR Peer Motion Manager Software with Recovery Manager
• 9 Remote Copy for Recovery Manager
  • Overview
  • How Remote Copy Works
  • Setting Up Remote Copy
    • Support for Remote Copy Modes and Policies
    • Support for GeoCluster for Microsoft Windows
  • Setting Up Remote Copy Volume Groups
    • Setting Up a Remote Copy Volume Group for Databases
    • Setting Up a Remote Copy Volume Group for Instances
  • Recovering a SQL Database from a Remote Copy Backup Server
• 10 Support and Other Resources
  • Related Documents
  • Typographical Conventions
  • Advisories
• A Server Virtualization Environments
  • VMWare and Microsoft Hyper-V Environments
• B Troubleshooting
• C Event Messages