HP Application Software Suite for Microsoft SQL manual Setting Up Remote Copy Volume Groups

Page 74

Support for Remote Copy Modes and Policies

Recovery Manager supports Remote Copy in synchronous and asynchronous periodic mode.

If you are using synchronous Remote Copy, the policies on the production system (the Remote Copy primary system) and the Remote Copy backup system must match. If the policies do not match, Recovery Manager cannot create virtual copies on a synchronous Remote Copy system.

However, if you manually specify an expiration value, a retention value, or both when you create a virtual copy, Recovery Manager creates the virtual copy on a synchronous Remote Copy system even if the policies on the Remote Copy primary and backup servers do not match.

NOTE: For more information on specifying values at the time you create virtual copies, see the description of the RMSql create command in “Using the Recovery Manager CLI” (page 42).

If you are using asynchronous periodic Remote Copy, you can create Recovery Manager virtual copies even if policies on the servers do not match. If policies do not match, the virtual copies use the policies on the Remote Copy backup server.

If you are running Remote Copy in a Synchronous Long Distance configuration, the virtual copies on the synchronous and asynchronous periodic Remote Copy backup servers do not have the exact same timestamp.

Support for GeoCluster for Microsoft Windows

Recovery Manager for SQL supports the use of both Remote Copy and HP 3PAR GeoCluster Software for Microsoft Windows:

When synchronous mode Remote Copy is used with Recovery Manager for SQL and GeoCluster, you can use Recovery Manager to create virtual copies on both the production system (the Remote Copy primary system) and the Remote Copy backup system.

When Synchronous Long Distance Remote Copy is used with Recovery Manager for SQL and GeoCluster, you can use Recovery Manager to create virtual copies on all three systems: the production system (the Remote Copy primary system), the synchronous mode Remote Copy backup system, and the asynchronous periodic mode Remote Copy backup system.

Setting Up Remote Copy Volume Groups

Setting Up a Remote Copy Volume Group for Databases

1.Identify the virtual volumes that contain the database and log files to be copied.

2.Create one (and only one) primary Remote Copy volume group per database.

NOTE: Recovery Manager supports multiple databases in one Remote Copy volume group if all the databases in the group belong to the same instance.

3.Add the virtual volumes belonging to the database and log files to the primary Remote Copy volume group, and add the associated secondary virtual volumes to the secondary volume group on the Remote Copy backup server.

CAUTION: Do not disperse files from one database over multiple primary Remote Copy volume groups. Recovery Manager does not support database and log files from one database existing in any location other than the one primary Remote Copy volume group created for that database.

4.Synchronize the Remote Copy primary and secondary volume groups.

74 Remote Copy for Recovery Manager

Image 74
Contents User’s Guide Documentation Contents Configuring Backup Software Using the Recovery Manager GUIRemote Copy for Recovery Manager Using the Recovery Manager CLIRecovery for Microsoft SQL Server Troubleshooting Event MessagesTypographical Conventions IntroductionRelated Documents Advisories Windows Server Requirements Overview of Recovery ManagerSystem 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 Pre-Installation Steps Installation and DeinstallationUpgrading to Recovery Manager 4.2.0 for SQL Installing Recovery Manager Verifying the Installation Understanding the RegistryDeinstalling Recovery Manager Configuring Recovery Manager Configuring Recovery ManagerConfiguring the SQL Database Grouping Volumes into Autonomic Groups Configuring Recovery Manager PoliciesConfiguring Mount Functionality 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 ServerOverview Configuring Backup SoftwareSetting Up Symantec NetBackup Before You BeginSetting Up HP Data Protector Cell Manager Access Configuring HP Data ProtectorSetting Up the HP Data Protector Backup Specification RequirementsUsing HP Data Protector Using Your Backup SoftwareUsing Symantec NetBackup RM installation location\log\nbulog\databasetimestamp.logOpening the Recovery Manager GUI Using the Recovery Manager GUIOverview of the Recovery Manager GUI Closing the Recovery Manager GUIUpdating Registration after Server Modification Unregistering a SQL Server Instance Setting the Recovery Manager PolicyHow Recovery Manager Policies Work Setting Recovery Manager Policies Retention Time RestrictionsConfiguring Email Notifications Modifying the Policy for a Virtual CopyHow Virtual Copy Creation Works Deleting Email ConfigurationsCreating Virtual Copies 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 ManagerBacking Up a Virtual Copy Manually Creating Backups at the Instance or Database LevelUnmounting a Virtual Copy Scheduling Automatic Backups of an Instance or Database Creating a Backup of a Virtual Copy Removing a Backup from the RepositoryRestoring Instances, Databases, and Volumes 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 DescriptionsRecovery Manager Commands Using the Recovery Manager CLIRecovery Manager for SQL Server Command Line Interface CLI SQL Server RMSql analyzeRMSql analyze -s SQL server -sync -f 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 Instance virtual copy limit RMSql policyDatabase virtual copy limit RMSql policy -exp 30d -s SQL server Retain timehHdDRMSql policy -n 5 -s SQL server Recovery Manager Commands RMSql portconfig -n RMSql portconfigRMSql portconfig -n number -s WindowsHost RMSql portconfig -n 9999 -s WindowsHostRMSql remove RMSql remove -s SQL server -t timestampWindowsHost RMSql reportRMSql report -s WindowsHost -output OutputDirectory RMSql report -s Grampus -output c\MyReportRMSql repository -a d\3parvv RMSql repositoryRMSql repository -a alter location -r AltLocation RMSql restoreSystemDrive\3parSnapshot by default RMSql restore -snap -s server1 -d testdb -t NorecoveryRMSql restore -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 -prt RMSql timeconfigRMSql timeconfig RMSql timeconfig -bktRMSql unmount Running Recovery Manager as a Scheduled JobScheduling an Automated Task in Windows RMSql unmount -s SQL server -t timestampFor example Recovering Data with HP 3PAR Recovery Manager Recovery for Microsoft SQL ServerMicrosoft SQL Server Recovery Models 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 Support for Remote Copy Modes and Policies Setting Up Remote Copy Volume GroupsSetting Up a Remote Copy Volume Group for Databases 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