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

*: When a VDI metafile storage directory is registered in the SQL Options tab of the Setup Application
Agent dialog box, the metafile is stored in the registered directory. The file name is
backup-ID_database-ID.dmp . When default is selected for the VDI metafile storage directory,
the metafile is stored in the directory that contains the file whose management number ( file_id ) for
SQL Server in the database file is a minimum value. The file name is META_xxx.dmp .
Databases are backed up and restored in units of volumes, so the object configuration of an SQL
Server database requires the following:
• Configure each instance so that its data files are on one volume. In addition, do not place data
files of multiple instances on a single volume.
• The following should not be placed in the same directory as the database configuration files
(
*.mdf , *.ndf , and *.ldf ):
• Metafile directory (only when specified)
• Transaction log backup files
Roll-forward recovery processing can only be performed if the above directory and file are placed
on separate volumes. (In the event of a restoration, this prevents the metadata and transaction log
files from reverting to a previous state.) If this requirement is not satisfied, the backup terminates
with an error.
• You can use the following characters when naming a database:
• ASCII characters
• Multi-byte characters (one character must be expressed using 1- or 2-byte characters)
However, do not use the following characters:\ / : , ; * ? < > | “
• Do not use names in the following form for database data files:
META_database-ID.dmp
Where database-ID is a 10-digit number.
• In a cluster environment, specify a user on each node for the owner of a database subject to
backup. Local users with the same user name and password on different nodes are not considered
to be the same user. Therefore, use a domain user account that is common to all nodes. If a failover
is performed to a node where the database-owner user does not exist, backup fails because the
database owner is unknown.
• If the system databases (master, model, and msdb) are to be backed up, specify, as the output
destination for SQL Server error log files, a volume different than the one that contains the system
databases. If the system database to be backed up is specified as the destination, when the system
database is restored from the secondary volume, the SQL Server error log files are also restored.
As a result, the contents of the error log files return to the state they were before the backup, and
consequently the error log information generated after the backup will be lost.
• Store tempdb on a different volume from the one used to store a user database to be backed up.
If the same volume is used, tempdb remains online and is overwritten with data restored from the
secondary volume when restoring from the user database only. This causes SQL Server to go into
an invalid state. To recover SQL Server from this state, it must be restarted to recreate tempdb.
After restarting SQL Server, move tempdb to a volume separate from the user database and attempt
the restore again.
• A backed-up database cannot be restored if the SQL Server versions do not match. For example,
a database backed up from a database server running SQL Server 2005 cannot be restored to
a database server running SQL Server 2008.
• In a cluster environment, install an SQL Server instance as a failover cluster.
The following points must be considered if you are using SQL Server 2005 or SQL Server 2008:
User Guide 379