HP XP Array Manager Software User Manual

Page 143

Advertising
background image

You can use the

SQL_LOGIN_TIMEOUT

parameter to specify the SQL Server login timeout option

in

sqlinit_

instance-name

.conf

.

A login request timeout is likely to occur in environments with high network loads, which may
result from a large-scale database.

Specifying the SQL Server automatic recovery time
Specify the recovery time if the command terminates with an error because the automatic recovery
processing at SQL Server startup is incomplete during restoration of the SQL Server database
(when the error message

KAVX1008-E

with the detailed message

DRM-11011

and code

5180

or

904

is output).

You can use the

SQL_AUTORECOVERY_TIME

parameter to specify the SQL Server automatic re-

covery time in

sqlinit_

instance-name

.conf

.

The following table lists whether the parameter can be specified for each combination of restoration-
target databases.

Table 37 Relationship between SQL_AUTORECOVERY_TIME parameter and restored objects

Parameter specifica-
tion

SQL Server
automatic re-
covery pro-
cessing

Restoration
type

System config-
uration

Restored object

U

S

Needed

#

Performed

Restoration
while cluster
resources are
offline

Cluster

--

Yes

Needed

#

Performed

--

Non-cluster

Needed

#

Performed

Restoration
while the
cluster re-
sources are
offline

Cluster

Yes (all)

Yes

Needed

#

Performed

--

Non-cluster

Needed

#

Performed

Restoration
while the
cluster re-
sources are
offline

Cluster

Yes (partial)

Yes

Needed

#

Performed

--

Non-cluster

Needed

#

Performed

Restoration
while the
cluster re-
sources are
offline

Cluster

Yes (all)

--

Not needed

Not performed

Restoration
while the
cluster re-
sources are on-
line

Not needed

Not performed

--

Non-cluster

Application Agent CLI User Guide

143

Advertising