HP XP P9000 Command View Advanced Edition Software - Manual (Page 383)

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, P9000 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.
P9000 RAID Manager configuration definition files
For replica management, the configuration definition (HORCM) files of a linked P9000 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 383