Post reply

Kill Process

  • July 14, 2009 at 2:42 am

    #223590

    Hi Everyone,

    I am trying to a kill a process using Kill command.When i execute i got this message

    SPID 54: transaction rollback in progress. Estimated rollback completion: 43%. Estimated time remaining: 148100 seconds.

    This is taking too long. I searched for a solution and i got it is to restart sql server.

    Is there a better solution for solving without restarting sql server

    Pls advice ExPeRts

    Thanks in advance

    Milesh

  • July 14, 2009 at 2:52 am

    #1024280

    The rollback has to complete. If it didn't, you'd be left with an inconsistent (suspect) database. There is no way you can stop that rollback. Even if you restart SQL, the rollback has to be done, it'll just be done as part of the restart-recovery on the database. If you're running standard edition, the database will be 'recovering' and inaccessible while the restart recovery completes.

    Wait. It's the best thing that you can do here.

    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

  • July 14, 2009 at 3:11 am

    #1024287

    Hi Gail Shaw,

    thank u so much for the fast reply

    SO i will wait.... to complete

    I had to kill the process because it was causing my tempdb log to grow by almost 10MB/sec.

    Can you tell me what could have caused this.

    with regards

    Milesh

Viewing 3 posts - 1 through 2 (of 2 total)

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