Home Forums SQL Server 2008 SQL Server 2008 Administration Can't Kill SPID “Transaction Rollback in Progress” RE: Can't Kill SPID “Transaction Rollback in Progress”

  • February 27, 2013 at 12:03 am

    #1591403

    Welsh Corgi (2/26/2013)

    I have had to restart the SQL Server Service, Set the Database OFFLINE and try to bring it back ONLINE and and force it to recover.

    Just a restart will do, no need for the rest.

    What's the query doing?

    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