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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Queries and data modification » Data manipulation statements


Transactions and data recovery

SQL Anywhere protects the integrity of your database in the event of a system failure or power outage. You have several different options for restoring your database server. For example, the log file that SQL Anywhere stores on a separate drive can be used to restore your data. When using a log file for recovery, SQL Anywhere does not need to update your database as frequently, and the performance of your database server is improved.

Transaction processing allows the database server to identify situations in which your data is in a consistent state. Transaction processing ensures that if, for any reason, a transaction is not successfully completed, then the entire transaction is undone, or rolled back. The database is left entirely unaffected by failed transactions.

The transaction processing in SQL Anywhere ensures that the contents of a transaction are processed securely, even in the event of a system failure in the middle of a transaction.

 See also