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

2. Specify the parameter in the sqlinit_instance-name.conf file.
Write the parameter starting from the far left, without spaces. Delimit the parameter name and
timeout value by an equal sign (=), and do not enter space or tab characters before or after the
equal sign. Lines beginning with # are assumed to be comment lines. If a parameter is specified
two or more times, the earliest value written is effective.
• To specify the SQL Server login timeout option
Add the SQL_LOGIN_TIMEOUT=login-timeout-value.
• To specify the SQL Server automatic recovery time
Add the SQL_AUTORECOVERY_TIME=SQL-Server-automatic-recovery-time.
The following tables show details of each parameter:
Table 45 Parameter defined in the sqlinit_instance-name.conf file (specification of SQL Server
login timeout option)
DefaultDescriptionParameter
None
In this parameter, specify the same number of
seconds as the waiting period for completion of a
request to log in to an SQL Server. If this parameter
is specified, a login to SQL Server uses the value is
specified in the SQL_ATTR_LOGIN_TIMEOUT attrib-
ute of the ODBC function SQLSetConnectAttr.
If the parameter is not specified, the SQL_ATTR_LO-
GIN_TIMEOUT attribute is not specified.
SQL_LOGIN_TIMEOUT
Note
The value specified for SQL_LOGIN_TIMEOUT must be smaller than the VDI generation
timeout period specified for the drmsqlinit command. If you specify a value greater than
the VDI generation timeout period, the drmsqlbackup command may encounter a VDI
generation timeout when waiting for the processing of the request for login to SQL Server
and may terminate with an error.
Table 46 Parameter defined in the sqlinit_instance-name.conf file (specification of SQL Server
automatic recovery time)
DefaultDescriptionParameter
0
In this parameter, specify the SQL Server
automatic recovery time (in seconds) for the
restoration command.
If this parameter is set to a value other than 0,
the system waits for completion of SQL Server
automatic recovery processing for the specified
period of time.
When you determine a value for
SQL_ATTR_LOGIN_TIMEOUT, add enough
time so that the value becomes about twice as
much as the time from the beginning to the end
of automatic recovery of the system databases
(master, model, msdb, and tempdb).
You can use the SQL Server log file to check the
amount of time from the beginning to the end
of automatic recovery of the system databases
(master, model, msdb, and tempdb).
SQL_AUTORECOVERY_TIME
CLI User Guide 147