You can load a transaction dump from Adaptive Server version 11.9.2, 12.0x, or 12.5x over a database dump or transaction dump that has preceded it in the load sequence.
However, if that transaction dump contains a create index transaction, then load transaction recovery treats that transaction’s sort record as the end of the log. Adaptive Server does not process any more log records in that transaction, and does not allow load transaction dumps in the load sequence. This message prints:
The pre-15.0 log for database '%.*s' includes a create index incompatible with this server version and operating environment. Only transactions completed before create index will be recovered.
This behavior is much like the point-in-time recovery that is affected by the load transaction until_time option.
In contrast, Adaptive Server should successfully load any database dump from one of the earlier versions, regardless of its content.
There is no content limitation in load database or load transaction when using a dump from a version 15.0 Adaptive Server.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
