can I kill a rollback

[daglugub37]

SO an update was taking much longer than expected. The sql was not wrapped in a transaction.

I killed it expecting it to just stop, and whatever was updated remain.

Instead it is rolling back.

Can I kill this rollback,

 

[mrdenny]

No you can't kill a roll back. When you kill a transaction all the data changes are rolled back. There is no way to stop the rollback.

The rollback will take about the same amount of time it took before you killed the query. If the query ran for 10 minutes the roll back should run for about 10 minutes.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com