HP XP Command View Advanced Edition Software User Manual

Page 144

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 39 Parameter defined in the sqlinit_instance-name.conf file (specification of SQL Server
login timeout option)

Default

Description

Parameter

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 40 Parameter defined in the sqlinit_instance-name.conf file (specification of SQL Server
automatic recovery time)

Default

Description

Parameter

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
(