HP StorageWorks P9000 Replication Manager Software 7.1 CLI User Guide (TB584-96026, May 2011)

Figure 45 Metafile allocation (in the cluster configuration)
Using a dynamic disk configuration
• Do not allocate a data file made up of multiple instances to a file system (drive) of a disk group
subject to backup and restoration.
• Allocate the following directories and files to a file system (drive) of a disk group different from
the one to which data files (*.mdf and *.ndf) are allocated. If these directories and files are
allocated to a file system (drive) of the same disk group, an error will occur when backup is ex-
ecuted.
• Metafile storage directory (only if a VDI metafile storage directory was specified with the
drmsqlinit command)
• Backup data of the transaction log
• To allocate a file that is made up of multiple databases to a file system (drive) of the same disk
group, you must collectively back up and restore all the databases. If these requirements are not
met when performing Application Agent backup, backup processing terminates with an error.
• To back up or restore databases individually, allocate database data files to a file system (drive)
of a different disk group.
• Store tempdb in a file system (drive) in a disk group other than that in which the user database
subject to backup is located. If it is stored in a file system (drive) of the same disk group then,
when the user database is restored, tempdb is overwritten by the data restored from the secondary
volume, while it is online, and consequently the SQL Server goes into an abnormal state. In this
case, restart the SQL Server to recreate tempdb and restore the server to a normal state. After re-
starting the SQL Server, specify a file system (drive) in a disk group other than that in which the
user database subject to backup is located, and then re-execute the restoration. Before re-executing
restoration, see “SQL Server database requirements for executing commands” on page 284 to
check if the database can properly be restored.
Using a cluster configuration
Do not register the service resources of multiple SQL Server instances into a cluster group.
Application Agent system configurations88