Volume sets, Host sets, Testing sql connectivity – HP 3PAR Application Software Suite for Microsoft SQL Licenses User Manual

Page 21: Volume sets host sets

Advertising
background image

HP 3PAR Storage System domain set. This configuration allows you to use just one Recovery
Manager backup server to manage all your database servers.

All hosts, users, and virtual volumes, including the backup server, must belong to the same
HP 3PAR Virtual Domain.

To mount a virtual copy or media backup to a server that is in a different HP 3PAR Virtual
Domain than the domain in which it was created, you must use the Recovery Manager CLI
command RMSql mount -ts.

To create a Remote Copy group for a virtual volume that is in a user-defined domain, the
associated virtual volume on the Remote Copy backup server must be in the same user-defined
domain.

To configure domain sets, use HP 3PAR CLI commands to:
1.

Ensure you are running HP 3PAR InForm Operating System Software 2.3.1 or higher.

2.

Ensure you have access to all domains.

3.

Create a domain set that contains all HP 3PAR Virtual Domains for all the database servers.

4.

Create a Command Provisioning Group (CPG) belonging to the new virtual domain.

5.

Create a virtual volume belonging to the CPG you just created.

6.

Create a host belonging to the virtual domain.

7.

Export the VLUN to the host.

8.

On the Recovery Manager backup and production servers, set the user for the HP 3PAR VSS
Provider Software.

9.

Ensure the HP 3PAR Storage System connection is good.

NOTE:

For more information on HP 3PAR CLI commands, see the HP 3PAR InForm OS

Command Line Interface Reference. For more information on HP 3PAR VSS Provider Software,
see the HP 3PAR VSS Provider Software for Microsoft Windows User’s Guide.

Volume Sets

To configure volume sets:

In a volume set, place either:

one database and its log files

one instance and its related files

Do not place one volume in more than one volume set.

Do not place unrelated volumes in a volume set.

Host Sets

You can configure your system with host sets and volume sets, or with host sets only. You can add
all nodes of a cluster to one host set.

Testing SQL Connectivity

After you install and configure Recovery Manager on the backup server and all of the production
servers, verify that your SQL instances are reachable:
1.

Log onto the backup server as the system administrator.

2.

Launch SQL Server Management Studio.

3.

In the Connect to Server window, enter or select the following:

Server type: Database Engine

Testing SQL Connectivity

21

Advertising