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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Querying and Modifying Data » Adding, changing, and deleting data » Data modification statements


Transactions and data recovery

Suppose that a system failure or power outage suddenly takes your database server down. SQL Anywhere is carefully designed to protect the integrity of your database in such circumstances. It provides you with a number of independent means of restoring your database. For example, it provides you with a log file that you can store on a separate drive so that should the system failure damage one drive, you still have a means of restoring your data. In addition, when you use a log file, SQL Anywhere does not have to update your database as frequently, which improves your database's performance.

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