SQL Server log file too large to manage - what's the fastest way to compact it?
Posted on 2007-12-05
I have a MS SQL Server 2000 file that is 99,146,176 KB size and takes up all of the C:\ drive. Obviously I try shrinking it but I keep getting the error to backup your log. I seriously do not need a single log of transaction that has occurred. How could I do just a delete of everything in there to reduce the file size?
Currently I ran a BACKUP LOG to DISK - not realizing the huge file size - how can I stop what is taking place without disrupting to follow your below comments?
I will not ever need but a log of what happened for only in the last week - I'm sorry if I don't know what size limitation will that be - but it is definitely not going to be that huge. How can I prevent this from happening in the future?