Manuals
/
HP
/
Computer Equipment
/
Software
HP
StoreServ Application Suite for Microsoft SQL E-Media manual 3PAR Confidential
Models:
StoreServ Application Suite for Microsoft SQL E-Media
StoreServ Application Suite for Microsoft SQL Media
1
42
136
136
Download
136 pages
3.05 Kb
39
40
41
42
43
44
45
46
<
>
Troubleshooting
Install
SQLServerName\default
Configuring Recovery Manager
Recovery Manager Commands
Defining a NetBackup Policy
Using the Recovery Manager CLI
Features Supported
Page 42
Image 42
3PAR Recovery Manager 3.0.2 for Microsoft SQL Server User’s Guide
4.8
Defining a NetBackup Policy
3PAR Confidential
Page 41
Page 43
Page 42
Image 42
Page 41
Page 43
Contents
3PAR Recovery Manager For Microsoft SQL Server User’s Guide
Revision Notice
Table of Contents
Configuring NetBackup for Recovery Manager
Using the Recovery Manager CLI
Server Virtualization Environments
Introduction
Audience
Related Documents
For Information About… Read the…
Organization
Typographical Conventions
Typeface Meaning Example ABCDabcd
Advisories
3PAR Confidential
Overview of Recovery Manager
Microsoft Volume Shadow Copy Service
VSS Component VSS Component Description
How VSS Works with Microsoft SQL Server
3PAR VSS Provider for Microsoft Windows Operation Overview
Recovery Manager Layout
Supported VSS Components
Recovery Manager Requirements
System Requirements
Features Supported
Features Not Supported
3PAR Confidential
3PAR Confidential
Installation and Deinstallation
Installing Recovery Manager
Click Start All Programs Accessories Windows Explorer
Click Next
Agree to the license agreement, then click Next
3PAR Confidential
3PAR Confidential
3PAR Confidential
3PAR Confidential
Verifying the Installation
Deinstalling Recovery Manager
Deinstalling Recovery Manager
Understanding the Registry
Name Value
Launch the Recovery Manager GUI for the first time
Configuring NetBackup for Recovery Manager
Overview
Defining a NetBackup Policy
3PAR Confidential
Select the Schedules tab and click New…
3PAR Confidential
3PAR Confidential
3PAR Confidential
3PAR Confidential
Configuring Recovery Manager
Installation Location
Configuring the SQL Database
Configuring Recovery Manager
Recovery Manager TCP/IP Port
SQL Connectivity Test
Server name enter the SQLserverName\instanceName
Troubleshooting SQL Connectivity
Formatting Partitions on a New 3PAR VLUNs
Windows Server
Using the Recovery Manager GUI
Overview of the Recovery Manager GUI
Menu Bar
Server Registration
Opening the Recovery Manager GUI
Closing the Recovery Manager GUI
Node Tree Pane
Server Registration
SQLServerName\default
3PAR Confidential
Setting the Recovery Manager Policy Configuration
Setting the Recovery Manager Policy Configuration
3PAR Confidential
Creating Instance or Database Virtual Copy
3PAR Confidential
Creating Instance or Database Virtual Copy
Creating a Remote Virtual Copy
Creating a Remote Virtual Copy for an Instance
Creating a Remote Virtual Copy for a Database
3PAR Confidential
Mounting a Virtual Copy
3PAR Confidential
Backing Up a Virtual Copy Using Veritas NetBackup
Unmounting a Virtual Copy
Backup at Instance Level
Backing Up a Virtual Copy Using Veritas NetBackup
3PAR Confidential
Backup at Database Level
3PAR Confidential
Creating a Backup at the Timestamp Level
Deleting Backup from the Repository
3PAR Confidential
3PAR Confidential
Restoring a Virtual Copy Using Veritas NetBackup
3PAR Confidential
Removing a Virtual Copy
3PAR Confidential
Using the Recovery Manager CLI
Recovery Manager Command Line Interface CLI
Recovery Manager Commands
Command
Example
Examples
RMSql create -s SQLVirtualServer -d test -rc Secondaryserver
3PAR Confidential
Command
RMSql analyze
RMSql display -s server1
3PAR Confidential
RMSql mount
3PAR Confidential
RMSql remove -s SQL Server -t timestamp
AltLocation -snap
RMSql restore -s server1 -d testdb -t
3PAR Confidential
RMSql unmount -s SQL Server -t timestamp
RMSql policy -n 5 -s SQL Server
3PAR Confidential
RMSql listbackup
RMSql report -s WindowsHost -output OutputDirectory
RMSql repository -a alter location -r
RMSql portconfig -n no -s WindowsHost
RMSql timeconfig
Running Recovery Manager as a Scheduled Job
Click RMSql.exe
Running Recovery Manager as a Scheduled Job
3PAR Confidential
3PAR Confidential
Recovery for Microsoft SQL Server
Recovery
Point-In-Time Recovery
Point-Of-Failure Recovery
SQL Instance Level File Copy Restore in an Mscs Environment
Volume Restore in an Mscs Environment
3PAR Confidential
Cluster res resourcename /maintoff
3PAR Confidential
3PAR Confidential
3PAR Confidential
Remote Copy for Recovery Manager
Purpose of Remote Copy
How it works
How to Setup the Remote Copy Feature
Set Up Remote Copy Group for Databases
Set Up Remote Copy Group for Instances
Recovering an SQL database from a Secondary Site
Recovering an SQL database from a Secondary Site
Server Virtualization Environments
VMWare and Egenera
Figure A-1.Server Virtualization Environment
Troubleshooting
Problem
3PAR Confidential
3PAR Confidential
3PAR Confidential
Index
GUI
IX.2
Revision History
Release Level Revision Summary
RH.2