Post reply

Rollback on Rebuild index does not end (KILL)

  • April 9, 2014 at 3:20 am

    #306524

    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!

  • April 9, 2014 at 3:30 am

    #1704414

    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 recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 9, 2014 at 3:36 am

    #1704415

    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 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply