HP 10400 Application Software Suite for Microsoft SQL Media LTU manual Configuring Backup Software

Page 24

5 Configuring Backup Software

Overview

HP 3PAR Recovery Manager Software for Microsoft SQL Server can be used with either Symantec NetBackup or HP Data Protector to back up and restore the virtual copies created by Recovery Manager.

If you are using backup software in the backup environment, you must install a backup master or client on the backup server.

NOTE: For information about the supported versions of Symantec NetBackup and HP Data Protector, see the latest HP 3PAR InForm OS Configuration Matrix. To obtain a copy of this documentation, go to http://www.hp.com/go/3par/, navigate to your product page, click Support for your product, and then click Manuals.

Before You Begin

Ensure that you have set up a storage unit for storing virtual copy backups. For more information, see the documentation for the backup software you are using.

Setting Up Symantec NetBackup

To set up your Symantec NetBackup software, see the Symantec NetBackup documentation.

To configure Symantec NetBackup to function with Recovery Manager for SQL, set the following parameters during the configuration process:

Backup Policy Parameter	Setting
Policy type	MS-Windows-NT
Clients	Select the machine on which the Recovery Manager Backup
	Server component is installed.

Collect disaster recovery information for Bare Metal Restore Ensure this option is unchecked.

Type of backup	User backup
Starting times for backups	Activate all the time slots:
	• Modify Day: Mon
	•	Start Time: 12:00:00AM
	• End Day: Sun
	•	End Time: 12:00:00AM
	•	Duration (days): 7

24 Configuring Backup Software

Image 24

Contents User’s Guide Documentation Contents Configuring Backup Software Using the Recovery Manager GUIUsing the Recovery Manager CLI Recovery for Microsoft SQL ServerRemote Copy for Recovery Manager Troubleshooting Event MessagesIntroduction Related DocumentsTypographical Conventions Advisories Overview of Recovery Manager System RequirementsWindows Server Requirements Additional System RequirementsRecovery Manager Requirements Running Recovery Manager on a Japanese OSFeatures Supported Features Not Supported Microsoft Volume Shadow Copy ServiceSupported VSS Components How HP 3PAR VSS Software Works with Microsoft SQL ServerRecovery Manager Layout Overview of Recovery Manager Installation and Deinstallation Upgrading to Recovery Manager 4.2.0 for SQLPre-Installation Steps Installing Recovery Manager Verifying the Installation Understanding the RegistryDeinstalling Recovery Manager Configuring Recovery Manager Configuring the SQL DatabaseConfiguring Recovery Manager Configuring Recovery Manager Policies Configuring Mount FunctionalityGrouping Volumes into Autonomic Groups Testing SQL Connectivity Volume SetsConfiguring the Host Computer and the HP 3PAR Storage System Troubleshooting SQL ConnectivityFormatting Partitions on a New HP 3PAR Vlun Windows ServerConfiguring Backup Software Setting Up Symantec NetBackupOverview Before You BeginConfiguring HP Data Protector Setting Up the HP Data Protector Backup SpecificationSetting Up HP Data Protector Cell Manager Access RequirementsUsing Your Backup Software Using Symantec NetBackupUsing HP Data Protector RM installation location\log\nbulog\databasetimestamp.logUsing the Recovery Manager GUI Overview of the Recovery Manager GUIOpening the Recovery Manager GUI Closing the Recovery Manager GUIUpdating Registration after Server Modification Setting the Recovery Manager Policy How Recovery Manager Policies WorkUnregistering a SQL Server Instance Setting Recovery Manager Policies Retention Time RestrictionsConfiguring Email Notifications Modifying the Policy for a Virtual CopyDeleting Email Configurations Creating Virtual CopiesHow Virtual Copy Creation Works Manually Creating a Virtual CopyCreating Remote Virtual Copies Scheduling Automatic Virtual CopiesAutomating Tasks Scheduling Automated Tasks with Task SchedulerMounting a Virtual Copy Managing Automated Tasks with Task ManagerManually Creating Backups at the Instance or Database Level Unmounting a Virtual CopyBacking Up a Virtual Copy Scheduling Automatic Backups of an Instance or Database Removing a Backup from the Repository Restoring Instances, Databases, and VolumesCreating a Backup of a Virtual Copy Restoring an Instance or Database with Volume Restore Restoring an Instance or Database with File Copy RestoreRestoring an Instance or Database from a Backup Analyzing and Synchronizing the RepositoryRemoving a Virtual Copy Viewing Event Message DescriptionsUsing the Recovery Manager CLI Recovery Manager for SQL Server Command Line Interface CLIRecovery Manager Commands RMSql analyze RMSql analyze -s SQL server -sync -fSQL Server SyncRMSql backup Example RMSql create RMSql create -s SQLServer -d test RMSql create -s SQLVirtualServer -d testUsing the Recovery Manager CLI RMSql deletebackup RMSql deletebackup -s server1 -d db1 -tRMSql display RMSql display -s server1RMSql listbackup RMSql mount RMSql policy Database virtual copy limitInstance virtual copy limit Retain timehHdD RMSql policy -n 5 -s SQL serverRMSql policy -exp 30d -s SQL server Recovery Manager Commands RMSql portconfig RMSql portconfig -n number -s WindowsHostRMSql portconfig -n RMSql portconfig -n 9999 -s WindowsHostRMSql remove RMSql remove -s SQL server -t timestampRMSql report RMSql report -s WindowsHost -output OutputDirectoryWindowsHost RMSql report -s Grampus -output c\MyReportRMSql repository RMSql repository -a alter location -rRMSql repository -a d\3parvv RMSql restore SystemDrive\3parSnapshot by defaultAltLocation Norecovery RMSql restore -s server1 -d testdb -tRMSql restore -snap -s server1 -d testdb -t SnapUsing the Recovery Manager CLI RMSql setvc RMSql setvc -s server1 -t 020409162103 -exp 2h RMSql setvc -s server1 -t 020409162103 -exp 30dRMSql timeconfig RMSql timeconfigRMSql timeconfig -prt RMSql timeconfig -bktRunning Recovery Manager as a Scheduled Job Scheduling an Automated Task in WindowsRMSql unmount RMSql unmount -s SQL server -t timestampFor example Recovery for Microsoft SQL Server Microsoft SQL Server Recovery ModelsRecovering 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 Remote Copy for Recovery Manager How Remote Copy WorksSetting Up Remote Copy Setting Up Remote Copy Volume Groups Setting Up a Remote Copy Volume Group for DatabasesSupport for Remote Copy Modes and Policies Support for GeoCluster for Microsoft WindowsRecovering a SQL Database from a Remote Copy Backup Server Setting Up a Remote Copy Volume Group for InstancesServer Virtualization Environments VMWare and EgeneraTroubleshooting Installpath\NetBackup\db\ Installpath\NetBackup\db\altnames\No.RestrictionsEvent Messages Event ID Event ID Event ID Event ID Provcfg conn -syncrc Yes