Seagate ST43401N/ND Información técnica descargar pdf (Pagina 85)

Migrating to Sybase Adaptive Server Enterprise 11.5 6-5

Adaptive Server Enterprise 11.5 If Your Current Version is 4.x

New Backup Server

As of 10.0, Backup Server manages all dumps. All backup and

recovery procedures are executed through remote procedure calls

(RPCs) between Adaptive Server and Backup Server. To allow these

procedures to execute, the allow remote access conﬁg parameter must

be set to “on”.

The following changes may affect your dump scripts:

• Dumps to the null device (Unix: /dev/null or VMS devices starting

with NL) are now prohibited

• If you have tapes without ANSI labels, existing dump commands

will overwrite the contents.

• If you have single ﬁle media (for example, QIC) with ANSI labels,

the dump command will behave as follows:

- If the tape has expired, the contents will be overwritten

without warning

- If the tape has not expired, you will be prompted to conﬁrm the

dump location or change tapes

• If you have multi-ﬁle media, you must append the

with init clause

to the dump command if you wish to overwrite the contents.

Otherwise the current dump will be appended to the end of the

tape.

Last Chance Threshold

The threshold manager is a new tool, as of release 10.0, for managing

space in segments, particularly the log segment. When you upgrade

all existing databases where the transaction log is on its own

segment, SQL Server installs a last chance threshold on the log

segment.

You need to decide how to use the last chance threshold before you

migrate your production system. The default behavior suspends

action when the last chance threshold on the transaction log is

reached, and all users hang until some action is taken.

You must create the

sp_thresholdaction stored procedure to deﬁne an

action, such as

dump transaction, when the last chance threshold is

reached. Otherwise, when you run out of space in your log, all users

hang indeﬁnitely. Test a last chance threshold procedure before you

upgrade your production databases.

1 2 ... 80 81 82 83 84 85 86 87 88 89 90 ... 171 172

Sin comentarios

Seagate ST43401N/ND Información técnica Pagina 85