SQL Server Performance Forum – Threads Archive
Rollback Transaction on Power Failure
Hi All, Always I find the needed answers for my questions in this forum, but this is the first time I’m writting a question, so I hope that I will get some help from you. Please note the following scenario: – User ‘A’ begins a transaction ‘R1’ to update the table ‘T1’, the transaction has been completed but not commited becuase of a power failure in the machine that issued that transaction. – User ‘B’ begins a different transaction ‘R2’ to read the table ‘T1’, this transaction (‘R2’) is created with the option to read uncommited data(this is necessary option in my application). The read data is the uncommited one from transaction ‘R1’ issued by user ‘A’. How to make user ‘B’ read the old data before transaction ‘R1’, how rollback transaction ‘R1’ or Is there an option in MS SQL or ADO.NET to rollback the transaction on connection lost? Thanks for your time.Hi,<br />in this case you can do it with third party tool like log pi , log explorer , log rescue <br />BTW What is your recovery model ?<br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
Hi,<br />have a look at these topics HTH<br /><br /><a href=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6144′ target=’_blank’ title=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6144′<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6144>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6144</a></a><br /><br /><a href=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6541′ target=’_blank’ title=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6541′<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6541>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6541</a></a><br /><br /><a href=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2407′ target=’_blank’ title=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2407′<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2407>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2407</a></a><br /><br /><a href=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4116′ target=’_blank’ title=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4116′<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4116>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4116</a></a><br /><br /><a href=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2318′ target=’_blank’ title=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2318′<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2318>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2318</a></a><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
<b>THANKS FOR ALL OF YOU …</b><br /><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]
]]>