Recovering from a Failed Upgrade

During the upgrade process, the transaction log may get full due to the catalog changes that are made. If so, log in to the new server using isql, and issue:

During the upgrade process, the transaction log may get full due to the catalog changes that are made. If so, log in to the new server using isql, and issue:
dump tran dbname with no_log
This frees the log space, and allow the upgrade process to continue.

In some cases, the pre-upgrade space estimations are insufficient for the data copy phase of the upgrade process. In this case, an error is generated letting you know there is insufficient space in the system segment for the upgrade. The upgrade process stops and waits for space to be provided.Log in to the new server using isql, and use alter database to increase the size of the database.

alter database dbname on device_name = "2m"
Note: In Adaptive Server, alter database allows you to specify the size to alter the database with the unit-specifier ‘m’, or ‘M’.