Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » Introducing UltraLite » UltraLite transaction and state management


Backing up and recovering data in UltraLite

If an application using an UltraLite database stops unexpectedly, the UltraLite database automatically recovers to a consistent state when the application is restarted. All committed transactions flushed to memory prior to the unexpected failure are present in the UltraLite database. All transactions not flushed at the time of the failure are rolled back.

UltraLite does not use a transaction log to perform recovery. Instead, UltraLite stores state information for every row to determine the fate of a row when recovering. See UltraLite row states.


UltraLite provides protection against system failures, but not from media failures. The best way of making a backup of an UltraLite application is to synchronize with a consolidated database. To restore an UltraLite database, start with an empty database and populate it from the consolidated database through synchronization.

In smaller UltraLite deployments, you can copy the database file to a desktop computer to provide a manual backup.


On Palm OS, you can also set the PALM_ALLOW_BACKUP connection parameter to true. This setting allows you to back up the database over HotSync. See UltraLite PALM_ALLOW_BACKUP connection parameter.

See also