Transactions and Recovery

A transaction is both a unit of work and a unit of recovery. Because SAP ASE handles single-step change requests as transactions, the database can be recovered completely in case of failure.

The SAP ASE recovery time is measured in minutes and seconds. You can specify the maximum acceptable recovery time.

Note: Grouping large numbers of Transact-SQL commands into one long-running transaction may affect recovery time. If SAP ASE fails before the transaction commits, recovery takes longer, because SAP ASE must undo the transaction.

If you are using a remote database with Component Integration Services, there are a few differences in the way transactions are handled. See the Component Integration Services User’s Guide.

If you have purchased and installed SAP ASE DTM features, transactions that update data in multiple servers can also benefit from transactional consistency. See Using SAP ASE Distributed Transaction Features.