Post reply

How to kill a redo log?

  • April 15, 2005 at 10:27 am

    #66030

    friends , i have done a query

    insert into tableY select * from tableX

     

    but it was very heavy and cancelled the query

    and my sql now is freezed, how can i cancel the roll back???

    i tried wiith the spid but it throwes

    KILL 63

    SPID 63: transaction rollback in progress. Estimated rollback completion: 2%. Estimated time remaining: 59819 seconds.

    the roll  back is not important for me only i want to kill the process..

     

  • April 15, 2005 at 11:53 am

    #552972

    If I'm not mistaken, (been there, done this...) you don't have much recourse.  The rollback is VERY important to SQL Server, (understandable).  Even if you turn off the machine and reboot, it has to recover. 

    I'm sure there are tricks around this, but you would need to instantiate them beforehand.  You may be stuck with just waiting now...

    I wasn't born stupid - I had to study.

  • April 15, 2005 at 3:53 pm

    #553029

    mmmm well i know that the rollback is important because keep the datas consistant, but i dont need the datas consistant for my transaction , my transaction is only an insert into a table, but i dont know if cancel the rolback can be important for another registers of my system,and yes you are right i have limited resources, i am working in my development area and i have a poor server, it is very stressing for me

    thanks

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

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