lardog
Hello,
I am having a problem with my web host handling a MS SQL problem that I am having.
--- ERROR ---
Microsoft OLE DB Provider for SQL Server error '80040e14'
The log file for database 'DATABASENAME' is full. Back up the transaction log for the database to free up some log space.
/bx/bannersupload.asp, line 88
--- END OF ERROR ---
I am using 2 ASP scripts BanManPro and LinkXpro and have for many years without any problems. I have used it on shared servers as well as my own dedicated.
I have always had a maintenance plan that ran every day and truncated the transaction logs every night. This is a very popular and widely used script.
I sent the author my problem and he responded:
*--- author statement ---
Is this SQL 7? If so, just check the Truncate Log on Checkpoint for both databases and you will be set. If it is SQL 2000, setup a maintenance plan that backs up the database and log file every day and then the log file will truncate at that time.
***--- end author statement -----
The log fills up after about a week or two and with only about 500 banner impressions a day then I have to open a ticket for them to clear the logs. This indicates to me that there does not seem to be a plan that truncates the file.
---THEIR MOST RECENT RESPONSE---
It isn't a case of following a developers instructions for this. They are used to these types of intensive scripts being on a dedicated server, with resources to spare, and waste, on multiple backups of DB's residing on the very same server.
We'll raise the transaction log once again, as allowing daily backups of the transaction log, on top of the backups already in place of the DB it's self, is simply not something that should be done on a shared server.
---END OF THEIR MOST RECENT RESPONSE---
I have had this problem since January.
Question 1: Does anybody have any idea of how to resolve this?
Question 2: Is it true that shared hosts do not set up maintenance plans to backup MS SQL transaction logs so that they can automatically truncate?
Any input and/or info that I can give my host would be appreciated.
Thank you,
Larry M.