ACID property in Sql Server

ACID property

Atomicity : If a particular part of transaction fails then the entire transaction should fail.
Consistency : All the constraints and data integrity rules have to be followed. Transaction should make the database from one valid state to another. There should not be any violation of defined rules of the database.
Isolation : Every Transaction should be independent and Isolated completely from one another. One Transaction should not interfere with another transaction.
Durability : Once a transaction is completed it should remain permanent and should not get affected by any power outage or any disk failures.

ACID property in Sql Server was last modified: October 1st, 2017 by Justin Antony

About Justin Antony

Leave a Reply