• GilaMonster (11/6/2013)


    Next time don't restart SQL while there's a large transaction rolling back.

    One question here, don't you think the T-log file will keep growing even during the rollback? If the data needs to be put again, won't it add those entries to the log file again and make it grow.

    I haven't tested this on my side yet, I think I can initiate a big delete on my machine, kill it and using undocumented functions, will try to read the entries in the log file.

    Thanks

    Chandan Jha