beautypg.com

HP XP Array Manager Software User Manual

Page 144

background image

Parameter specifica-
tion

SQL Server
automatic re-
covery pro-
cessing

Restoration
type

System config-
uration

Restored object

U

S

Needed

#

Performed

Restoration
while the
cluster re-
sources are
offline

Cluster

Yes (partial)

--

Not needed

Not performed

Restoration
while the
cluster re-
sources are on-
line

Not needed

Not performed

--

Non-cluster

Legend

Yes: Can be restored
--: Not applicable
S: System database
U: User database

#

If the command terminates with an error because the automatic recovery processing at SQL
Server startup is not complete during restoration, specify the

SQL_AUTORECOVERY_TIME

parameter.

The following shows the procedure for specifying a parameter:

To specify the login timeout option or automatic recovery time:

1.

Copy

sqlinit_

instance-name

.conf

.

Copy source

Application-Agent-installation-directory

\DRM\conf\MSSQL\sample\sqlinit.conf

Copy destination

Application-Agent-installation-directory

\DRM\conf\MSSQL\sqlinit_

target-instance-

name

.conf

Preparation for using Application Agent

144