Sql server database instances and physical volumes, Mount status of secondary volumes, Raid manager configuration definition files – HP XP P9000 Command View Advanced Edition Software User Manual

Page 387: Multi-target or cascade configurations, Cluster configurations (sql server), Recovery model (sql server), Copy groups and applications, Copy groups and backup catalogs

Advertising
background image

SQL Server database instances and physical volumes

Because SQL Server replicas operate on individual physical volumes, the object configuration of SQL
Server databases must meet the following requirement:

Data files to be stored on a particular disk drive must belong to the same instance. Data files from
different instances must not be stored on the same disk drive.

Mount status of secondary volumes

Unmount all secondary volumes before performing a backup or restore to a database server. Failing
to do so may cause unpredictable results. For example, RAID Manager might not operate normally,
a mount or unmount operation might fail, or a data inconsistency might occur. Also, note that
applications might be executed in the background by a service.

RAID Manager configuration definition files

For replica management, the configuration definition (HORCM) files of a linked RAID Manager instance
must be located in the Windows directory (

%windir%

).

Multi-target or cascade configurations

If a volume is used to configure more than one copy pair (for multi-target or cascade configurations),
the configurations for the volume need to be defined using the same instance number.

Cluster configurations (SQL Server)

The following considerations apply to cluster configurations:

If a database server is in a cluster configuration, specify a shared disk for the following:
• VDI metafile directory
• UNDO file directory

Add the shared disk indicated above to the cluster group defining the instance.

To create both Exchange and SQL Server cluster configurations on the same physical node, the
host IDs, application types, and virtual hosts must be specified correctly. Even if SQL Server inform-
ation is incorrectly specified for Exchange, or Exchange information is incorrectly specified for
SQL Server, an error might not be displayed. If the configuration is incorrect and the system con-
tinues to be used, abnormal operations may result.

Recovery model (SQL Server)

Replication Manager only supports the database recovery models "Full" or "Bulk-logged."

Copy groups and applications

A copy group should only contain copy pairs associated with a single application. If a copy group
contains copy pairs associated with multiple applications, backup and restoration operations may
have unpredictable results.

Copy groups and backup catalogs

The backup information in the backup catalog is managed based on using the copy group as a key.
Depending on the backup method, you might not be able to perform a restore, even though the backup

User Guide

387

Advertising