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

• 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 StorageWorks P9000 Replication Manager Software 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.
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)
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 facilitate management of VDI metafiles, HP recommends
that you do not specify a VDI metafile storage directory.
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.
3. Confirm that the SQL Server database configuration definition file (instance-name.dat) has been
created.
The SQL Server database configuration definition file is created in the following location:
Application-Agent-installation-directory\conf\MSSQL\instance-name.dat
CLI User Guide 143