Software Suite for Microsoft SQL Licenses User guide

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 Start→Control Panel→Stored User Names and Passwords and
click Add.
• In Windows 2008, click Start→Control Panel→User Accounts and click Manage your
network passwords.
In the Logon Information Properties dialog box, click Add.
• In Windows 2008 R2, click Start→Control Panel→User Accounts and click Manage your
credentials→Add 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