I was running an insert statment and filled up the db log files. The job stopped and I assumed that it rolled back. However the logs did not release themselves. I know that I cant just delete the logs...so how do I get the roll back to commit and clear the logs?
Is there any other way...I have a transaction that is runnig unlogged as well as the one that failed. the one that is running will take forever to run in the first place I would hate to kill it now...