Sunday, 12 June 2016

States of Transaction in sql server

Transaction goes on various steps before the complication. See the below diagram we will get the clear idea.
   

Begin transaction

This indicates the beginning of a transaction

Active phase

In this phase the running of the database operations or write sql queries for perform the tasks is done partially committed
 After performs the needed operations the transaction indicates end state and come to the phase partially committed and store in the buffer but not permanently.

Committed

 If the transaction was successfully executed it comes to the commit state and indicates the database that the operation was success

Fail

If any failure occur during the transaction before committed it comes to the fail state. The system failures can occur as transaction, system and media failures.

Terminate


After successfully committed or the rollback after the failures finally it indicate the transaction is over

No comments:

Post a Comment

If you have any doubt, please let me know.

Popular Posts