Post reply

killing a process that is rolling back

  • January 31, 2005 at 11:41 am

    #361931

    How do I kill a process that generate an error such as below.

    SPID 69: transaction rollback in progress. Estimated rollback completion: 28%. Estimated time remaining: 17082 seconds
    after running the following kill 69 with statusonly but the process refuse to disappear...
    Thanks

  • January 31, 2005 at 12:18 pm

    #539784

    Its refusing to disappear because it is rolling back.  It is undoing what it had done up to the time you killed it in that particular transaction.  If this is a production database, you need to let it finish, unless you already know that you are going to restore the database from a backup.  If you don't care about the data, you can kill it by restarting SQL.

    Steve

  • January 31, 2005 at 1:01 pm

    #539789

    After you restart, SQL will start rolling back the transaction again.

  • February 1, 2005 at 3:02 am

    #539876

    Make the database suspect and restore from backup. That way SQL will not rollback.

  • February 1, 2005 at 5:19 am

    #539898

    How do I make the database suspect?

  • February 1, 2005 at 7:46 am

    #539933

    managed to stop the offending process by stopping the process from windows...thanks

  • February 1, 2005 at 7:59 pm

    #540073

    use master

    go

    exec sp_MSkilldb 'database name'

    go

Viewing 7 posts - 1 through 6 (of 6 total)

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