Thursday 23 June 2016

What are the ACID properties in SQL SERVER

In This post we are going to see what are the ACID properties in SQL SERVER.


 ACID is an acronym of four important properties i.e Atomicity, Consistency, Isolation and Durability.

o   Atomicity
It ensures that any update occurs in the database, then either all or none of the transactions executed successfully.

o   Consistency
It ensures that any changes update in the database is consistent and logical after and before of the update committed successfully.

o   Isolation
It ensures that multiple transactions are executed simultaneously, Then each Transaction is isolated from each other till the transaction executed completely.

o   Durability
It ensures that the data will be restored when system crashes or power failure up to last committed successful transaction. Durability ensures that the data is permanent after updating.

No comments:

Post a Comment