A transaction is both a unit of work and a unit of recovery. Because Adaptive Server handles single-step change requests as transactions, the database can be recovered completely in case of failure.
The Adaptive Server recovery time is measured in minutes and seconds. You can specify the maximum acceptable recovery time.
The SQL commands related to recovery and backup are discussed in “Backup and recovery of transactions”.
Grouping
large numbers of Transact-SQL commands into one long-running transaction
may affect recovery time. If Adaptive Server fails before the transaction
commits, recovery takes longer, because Adaptive Server 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 Adaptive Server DTM features, transactions that update data in multiple servers can also benefit from transactional consistency. See Using Adaptive Server Distributed Transaction Features.
