HP Application Software Suite for Microsoft SQL manual Configuring Recovery Manager Policies

Models: Application Software Suite for Microsoft SQL 7450 Application Software Suite Microsoft SQL Media LTU 10400 Application Software Suite for Microsoft SQL Media LTU

1 84
Download 84 pages 33.33 Kb
Page 20
Image 20

NOTE: The TCP/IP port used by Recovery Manager for SQL must be the same on all servers.

Changing a Production Server Port from the Backup Server

1.On the backup server, run the following Recovery Manager CLI command:

RMSql portconfig -s <Windows_host/production_server> -n <port_number>

2.On the production server, restart the Recovery Manager for SQL service.

Configuring Recovery Manager Policies

To use the Recovery Manager GUI to set database policies, see “Using the Recovery Manager GUI” (page 27).

To use the Recovery Manager CLI to set database policies, see “Using the Recovery Manager CLI” (page 42), for information about using the RMSql policy command.

Configuring Mount Functionality

The Windows automount feature is not compatible with Recovery Manager. To ensure that the Windows automount feature is disabled:

1.Open a command prompt (cmd) window.

2.Enter: diskpart

3.At the DISKPART prompt, enter: automount disable

4.Exit the command prompt window.

Managing SQL Servers across Multiple Active Directory Domains

If you are configuring Recovery Manager to work with SQL Servers across multiple Active Directory domains, you must store the appropriate login and password in the Windows user account on the backup server.

1.On the backup server:

In Windows 2003, click StartControl PanelStored User Names and Passwords and click Add.

In Windows 2008, click StartControl PanelUser Accounts and click Manage your network passwords.

In the Logon Information Properties dialog box, click Add.

In Windows 2008 R2, click StartControl PanelUser Accounts and click Manage your credentialsAdd a Windows credential.

2.In the Log on to field (or, for Windows 2008 R2, the Internet or network address field), enter the network location to which you want automatic access.

You can use a wildcard if you want access to multiple computers on a domain. For example: *.aztec.com

3.Enter the appropriate login and password.

4.Repeat these steps for all SQL Server domains in the Recovery Manager configuration.

Grouping Volumes into Autonomic Groups

You can group virtual volumes into autonomic groups (domain sets, volume sets, or host sets).

Domain Sets

If your SQL Server configuration involves multiple database servers that belong to different HP 3PAR Virtual Domains, you can use the domain set feature to group these virtual domains into one

20 Configuring Recovery Manager

Page 20
Image 20
HP Application Software Suite for Microsoft SQL Configuring Recovery Manager Policies, Configuring Mount Functionality