Trending DB2/SQL Discussions

Follow

Ask the Community


Ask any professional question and get answers from other specialists.

Stream language
Raghvendra Naik Gaonkar's image
Question added by Raghvendra Naik Gaonkar 1st class Tabla Examination
11 years ago

Can we rollback a committed transaction in Transact SQL? How?‎

This might not be possible as a part of DML directly, but can we use SQL logs or some filters or anything in the tables to achieve this?‎

Answers:
10
Followers:
Views:
2518
Vote Count:
1
Answer should contain a minimum of 25 characters.
Mohd shahnawaz khan's image
Question added by Mohd shahnawaz khan Associate Project Cognizant Technology Solution
11 years ago
Answers:
1
Followers:
Views:
111
Vote Count:
0
Answer should contain a minimum of 25 characters.
Mohamed Gad's image  
Answer added by  Mohamed Gad, Support Developer, Simpl Group
10 years ago

As mentioned earlier, you cannot rollback a transaction that is committed. However, you may use transaction logs to restore the database to an earlier state. In order to ... See More

rakan haddad's image  
Answer added by  rakan haddad, Oracle and Databse Developer, Takarub Telecommunication Company
10 years ago

No you cant 

Deepika Kumari's image  
Answer added by  Deepika Kumari, Software Engineer, Wipro Technologies
10 years ago

It is impossible to rollback after the transaction is commited.

Ganesh Sampat Abdagire's image  
Answer added by  Ganesh Sampat Abdagire, Senior .NET Developer, Qatar Islamic Bank
10 years ago

No you can not rollback the tranaction once commited.

Ashraf Abu Saed's image  
Answer added by  Ashraf Abu Saed
10 years ago

Yes you can from sysadmin cancel the workflow and then you can use rollback_transaction procedure to delrte transaction using transaction_id

tariq abbas's image  
Answer added by  tariq abbas, Professional Services Engineer (Java/Android Developer/Blockchain), NIFT
10 years ago

once commited can't be rolled back .

Adnan Hamdani's image  
Answer added by  Adnan Hamdani
10 years ago

You can't rollback any transaction once it is commited. but you need to do backup the database with transaction log. when ever you need to rollback, just restore the ... See More

Rajesh K's image  
Answer added by  Rajesh K, ISP Manager, CENPAC NET INC
10 years ago

Create a snapshot of database, then execute transaction. To undo the transaction, restore from the snapshot