A transaction dump from 11.9.2, 12.0x, or 12.5x can be loaded atop a database dump or transaction dump which has preceded it in the load sequence.
However, if that transaction dump contains a create index transaction, then load transaction recovery will treat that transaction’s sort record as the end of the log. No more log records in that transaction dump will be processed, and no more transaction dumps in the load sequence will be allowed to load. This behavior is much like the point-in-time recovery that is effected by load transaction’s until_time option. The following message is printed when load transaction terminates due to the above mentioned reason:
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.
In contrast, any database dump from one of those releases should be successfully loaded by Adaptive Server, 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. |
|
|
