HP 7450 Application Software Suite Microsoft SQL Media LTU manual Configuring HP Data Protector

Page 25

NOTE: If the backup server is running the NetBackup client interface, NetBackup cannot validate the policy.

NOTE: If you add the NetBackup path to the system’s PATH environment variable after you install HP 3PAR Recovery Manager Software for Microsoft SQL Server, you must restart Recovery Manager for your changes to take effect.

Configuring HP Data Protector

Requirements

HP Data Protector Software 6.2

Data Protector patch for omnidl (# DPWIN_00514)

Each data list name (also known as the backup specification) must be unique across the entire system

Setting Up the HP Data Protector Backup Specification

To use HP Data Protector with Recovery Manager, you must set up a default backup specification. The backup specification specifies the default mount point and the necessary devices for tape backup.

1.Open the Data Protector GUI.

2.Select BackupAdd Backup.

3.In the Create New Backup dialog box, select Blank_Filesystem_Backup and click OK.

4.Click Next (do not select any items).

5.Select the device that Data Protector is to use for backups.

6.Click Next until the Manual add... appears.

7.Click Manual add...

8.Select Windows filesystem and click Next.

9.Enter the appropriate client system, mount point, and description. HP recommends:

Client system

<server_used_as_backup_client>

Mount point

C:

Description

default

NOTE: Recovery Manager uses this information only to create a backup template. Recovery Manager does not use the actual data entered.

10.Click Next until the Finish button is enabled.

11.Save the backup specification.

When you issue the RMSql backup command with the -dloption, use the name with which you saved the backup specification (e.g., DPbackup) as the value of the -dloption.

Setting Up HP Data Protector Cell Manager Access

To use HP Data Protector with Recovery Manager, you must enable the system accounts on the registered client system to access the Data Protector Cell Manager.

1.Open the Data Protector GUI.

2.In the toolbar drop-down list, select Users.

3.Under the Users folder in the left pane, select adminSYSTEM.

4.In the Client system drop-down list on the General tab in the right pane, select <Any>.

Configuring HP Data Protector 25

Image 25
Contents User’s Guide Documentation Contents Using the Recovery Manager GUI Configuring Backup SoftwareRecovery for Microsoft SQL Server Using the Recovery Manager CLIRemote Copy for Recovery Manager Troubleshooting Event MessagesRelated Documents IntroductionTypographical Conventions Advisories System Requirements Overview of Recovery ManagerWindows Server Requirements Additional System RequirementsRunning Recovery Manager on a Japanese OS Recovery Manager RequirementsFeatures Supported Microsoft Volume Shadow Copy Service Features Not SupportedHow HP 3PAR VSS Software Works with Microsoft SQL Server Supported VSS ComponentsRecovery Manager Layout Overview of Recovery Manager Upgrading to Recovery Manager 4.2.0 for SQL Installation and DeinstallationPre-Installation Steps Installing Recovery Manager Understanding the Registry Verifying the InstallationDeinstalling Recovery Manager Configuring the SQL Database Configuring Recovery ManagerConfiguring Recovery Manager Configuring Mount Functionality Configuring Recovery Manager PoliciesGrouping Volumes into Autonomic Groups Volume Sets Testing SQL ConnectivityTroubleshooting SQL Connectivity Configuring the Host Computer and the HP 3PAR Storage SystemWindows Server Formatting Partitions on a New HP 3PAR VlunSetting Up Symantec NetBackup Configuring Backup SoftwareOverview Before You BeginSetting Up the HP Data Protector Backup Specification Configuring HP Data ProtectorSetting Up HP Data Protector Cell Manager Access RequirementsUsing Symantec NetBackup Using Your Backup SoftwareUsing HP Data Protector RM installation location\log\nbulog\databasetimestamp.logOverview of the Recovery Manager GUI Using the Recovery Manager GUIOpening the Recovery Manager GUI Closing the Recovery Manager GUIUpdating Registration after Server Modification How Recovery Manager Policies Work Setting the Recovery Manager PolicyUnregistering a SQL Server Instance Retention Time Restrictions Setting Recovery Manager PoliciesModifying the Policy for a Virtual Copy Configuring Email NotificationsCreating Virtual Copies Deleting Email ConfigurationsHow Virtual Copy Creation Works Manually Creating a Virtual CopyScheduling Automatic Virtual Copies Creating Remote Virtual CopiesScheduling Automated Tasks with Task Scheduler Automating TasksManaging Automated Tasks with Task Manager Mounting a Virtual CopyUnmounting a Virtual Copy Manually Creating Backups at the Instance or Database LevelBacking Up a Virtual Copy Scheduling Automatic Backups of an Instance or Database Restoring Instances, Databases, and Volumes Removing a Backup from the RepositoryCreating a Backup of a Virtual Copy Restoring an Instance or Database with File Copy Restore Restoring an Instance or Database with Volume RestoreAnalyzing and Synchronizing the Repository Restoring an Instance or Database from a BackupViewing Event Message Descriptions Removing a Virtual CopyRecovery Manager for SQL Server Command Line Interface CLI Using the Recovery Manager CLIRecovery Manager Commands RMSql analyze -s SQL server -sync -f RMSql analyzeSQL Server SyncRMSql backup Example RMSql create RMSql create -s SQLVirtualServer -d test RMSql create -s SQLServer -d testUsing the Recovery Manager CLI RMSql deletebackup -s server1 -d db1 -t RMSql deletebackupRMSql display -s server1 RMSql displayRMSql listbackup RMSql mount Database virtual copy limit RMSql policyInstance virtual copy limit RMSql policy -n 5 -s SQL server Retain timehHdDRMSql policy -exp 30d -s SQL server Recovery Manager Commands RMSql portconfig -n number -s WindowsHost RMSql portconfigRMSql portconfig -n RMSql portconfig -n 9999 -s WindowsHostRMSql remove -s SQL server -t timestamp RMSql removeRMSql report -s WindowsHost -output OutputDirectory RMSql reportWindowsHost RMSql report -s Grampus -output c\MyReportRMSql repository -a alter location -r RMSql repositoryRMSql repository -a d\3parvv SystemDrive\3parSnapshot by default RMSql restoreAltLocation RMSql restore -s server1 -d testdb -t NorecoveryRMSql restore -snap -s server1 -d testdb -t SnapUsing the Recovery Manager CLI RMSql setvc RMSql setvc -s server1 -t 020409162103 -exp 30d RMSql setvc -s server1 -t 020409162103 -exp 2hRMSql timeconfig RMSql timeconfigRMSql timeconfig -prt RMSql timeconfig -bktScheduling an Automated Task in Windows Running Recovery Manager as a Scheduled JobRMSql unmount RMSql unmount -s SQL server -t timestampFor example Microsoft SQL Server Recovery Models Recovery for Microsoft SQL ServerRecovering Data with HP 3PAR Recovery Manager Preparing for the Recovery ProcessRecovering All Data with Point-of-Failure Recovery Performing a Point-of-Failure Recovery Recovering All Data with Point-of-Failure Recovery How Remote Copy Works Remote Copy for Recovery ManagerSetting Up Remote Copy Setting Up a Remote Copy Volume Group for Databases Setting Up Remote Copy Volume GroupsSupport for Remote Copy Modes and Policies Support for GeoCluster for Microsoft WindowsSetting Up a Remote Copy Volume Group for Instances Recovering a SQL Database from a Remote Copy Backup ServerVMWare and Egenera Server Virtualization EnvironmentsTroubleshooting Installpath\NetBackup\db\altnames\No.Restrictions Installpath\NetBackup\db\Event Messages Event ID Event ID Event ID Event ID Provcfg conn -syncrc Yes