Question : This question already has answers here: How to identify which query is filling up the tempdb transaction log? […]
Tag: rollback
Keep local variable after rollback in mysql
Question : I wish to keep local variable from stored procedure even if rollback occurres. In following procedure, i “register” […]
is it possible to rollback only a partition/subpartition?
Question : Is it possible to create a savepoint and to rollback only a partition of a table? Lets assume […]
Implementing a Record Keeper/Rollback System for a MySQL Database
Question : What’s the best way to create a record keeping table for all actions in my database? I have […]
Why did a SQL Server Restart roll-back seemingly committed transactions?
Question : I am using SQL Server 2014 Express It seems that restarting SQL Server when an event such as […]
Copy a Large INNODB table in MySQL
Question : I have an INNODB table that’s > 93 million rows. A lot of the data is considered “temp” […]
Find history of rollbacks on SQL Server 2012 [duplicate]
Question : This question already has answers here: Get transactions that failed or were never committed (3 answers) Closed 5 […]
after executing a back up cmd (via query) how to kill it
Question : I have a big database (150 GB) that needs a back up and I don’t have space in […]
Rollback parent procedure on failure in MySQL
Question : I have the following two procedures on my server: CREATE DEFINER=`someone`@`localhost` PROCEDURE `NewMagnet`( IN `nick` VARCHAR(32), IN `tth` […]
How to recover auto committed transaction in Oracle with normal privilage
Question : I have updated the table & need to rollback that changes. I have tried Rollback work command but […]