Rollback on Rebuild index does not end (KILL)
-
Hello,
On a production server and a heavily queried database I had to kill the process doing a rebuild on a clustered index for a big table and now the transaction rollback is in progress but does not seem to end. (Estimated rollback completion: 0%. Estimated time remaining: 0 seconds ).
The database is down.
Will the drop of the index stop the rollback?
Thank you!
-
You won't be able to drop it.
You can try a restart of SQL. It's not a general solution for rollbacks, only for the specific case of what looks like a stuck rollback (Estimated rollback completion: 0%. Estimated time remaining: 0 seconds). If the estimations said anything else, I'd tell you to wait it out.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
Thank you so much for your answer!
It actually finished after posting the message
even though the message for KILL WITH STATUSONLY : Estimated rollback completion: 0%. Estimated time remaining: 0 seconds , remained until the end.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply