HP Serveur lame HP ProLiant BL465c Gen8 - Manual (Page 142)

Creating a database configuration definition file
This section describes how to create a database configuration definition file when backing up an SQL
database.
Creating a configuration definition file for SQL Server database backup
Use the drmsqlinit command to register the information about SQL Server.
The information to be registered includes the following:
• Storage directory for the VDI metafiles
• VDI generation timeout period
• Storage directory for the UNDO log files
• Storage directory for the backup files (for transaction logs)
For details on the SQL Server database information to be registered, see the description of the
drmsqlinit command in the manual HP P9000 Replication Manager Software Application Agent
CLI Reference Guide.
In an environment in which one system has multiple SQL instances, specify a separate directory for
each instance when registering the metafile storage direction, the
UNDO log file storage directory, or
the backup file storage directory for transaction logs.
In a cluster configuration, specify a VDI metafile storage directory, UNDO log file storage directory,
and log file storage directory on shared disks that can be referenced by both the active server and
standby server. If you do not specify a VDI metafile storage directory, VDI metafiles are stored in the
same location as the SQL Server database data files. To easily manage VDI metafiles, HP recommends
that you do not specify a VDI metafile storage directory.
To register SQL Server information:
1. Execute the drmsqlinit command with the SQL Server instance name specified in its argument.
To use SQL Server's default instance, specify DEFAULT .
PROMPT> drmsqlinit instance-name
2. Register the following items according to the output messages:
• Storage directory for the VDI metafiles
• VDI generation timeout period
• Storage directory for the UNDO log files
• Storage directory for the backup files (for transaction logs)
You need to confirm that the VDI generation timeout period is appropriate by actually backing
up the SQL Server database. In this stage (before operation checking), specify a value greater
than your prediction (e.g., 1000 seconds). After operation checking is complete, measure the
VDI freeze time and re-specify the timeout period using the
drmsqlinit command. For
information on how to measure the VDI freeze time during operation checking, see the explanation
below.
Both the UNDO log file storage directory and transaction log backup file directory are optional.
Note, however, that if you do not specify an UNDO log file storage directory, you cannot restore
or recover the SQL Server database in read-only mode. Note also that if you do not specify a
transaction log backup file storage directory, you cannot obtain transaction logs.
Preparation for using Application Agent 142