HP 3PAR Recovery Manager Software for Microsoft SQL Server Licenses - Manual (Page 75)

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.
Setting Up a Remote Copy Volume Group for Instances
1. Identify the virtual volumes that contain all database(s) and log files to be copied.
2. Create one primary Remote Copy volume group for this instance.
3. Add all virtual volumes that belong to this instance (all 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: The relationship between instances and Remote Copy volume groups is 1:1.
•
You must add files from only one instance to a primary Remote Copy volume group.
•
You must add files from only one instance to one primary volume group.
◦ Do not disperse files from one instance over multiple primary Remote Copy volume
groups.
◦ Do not add files from multiple instances to the same Remote Copy volume group.
If you do not ensure your system meets these requirements, you run the risk of data corruption
and loss.
4. Synchronize the Remote Copy primary and secondary volume groups.
Setting Up Remote Copy Volume Groups 75