Log file for MS SQL Server is full
Posted on 2001-08-06
I have written a Visual Basic application that is attempting to write 120,000 records to a table in a Microsoft SQL Server database.
However, as I add the records, the adding process slows down to a crawl. After adding 50,000 records, I aborted the add job as it was adding records very, very slowly.
Upon looking at the available space on the drive, I found that there was just a few megabytes left. When I tried to delete the 50,000 records, MS SQL Server gave me an error message saying that the transaction log file for the database was full and said I should backup the transaction log for the database to free up some log space.
As I don't do checkpoints, I don't care about the transaction log. So how can I get around this problem when I want to add 120,000 records at one time? Do I need to turn the transaction log off somehow?
Thank you for your input.