Saturday, June 9, 2012

What are the acid properties in sql server?

In sql server every transaction should follow acid properties
Atomicity
Consistency
Isolation
Durability

Atomicity: transaction ensures that either modifications are committed or not committed.
Consistency: The data should be in consistent state when transaction process is completed.
Isolation: A transaction work in isolation and does not allow other transactions to work concurrently on same piece of work.
Durability: Data is permanent once transaction is completed  and it can be recovered when system fails.

No comments:

Post a Comment