Post reply

Kill/Rollback : SPID 260: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.

  • May 7, 2008 at 11:12 pm

    #190306

    Kill/Rollback :

    SPID 260: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.

    I Don't Restart Service . How Can Do IT ?????????????

  • May 8, 2008 at 12:01 am

    #812224

    It seems that you have killed a process so please wait for some time and see if the rollback completes. Its always good to use,

    Kill Spid WITH STATUSONLY option because it will reflect the % of rollback completed.

    If its taking longer for rollback to get completed you can restart Sql Services and see the database recovery status in the error log.

    [font="Verdana"]- Deepak[/font]

  • May 8, 2008 at 11:02 pm

    #812797

    Thnks.

  • May 9, 2008 at 11:47 am

    #813273

    This could take a while depending on what the process was doing. I've seen them take hours, so be patient, or you will end up with a suspect database

    Marvin Dillard
    Senior Consultant
    Claraview Inc

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

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