Added: December/29/2008 at 9:05am | IP Logged

Hi Chris,

Something else to look at...the aspbanner_log.ldf file is growing giganticly, currently at 1.7 GB.  Is there any way to control this log file with aspbanner or is it all a matter going through SQL Server? 

Added: December/29/2008 at 11:59am | IP Logged

I've experienced the same thing on one of my busy setups
I found a 17gb log file and I was like WTF.

Anyway, it's a sql server thing. By default SQL logs every single sql query/transaction.

You have to send SQL a command via query analizer that basically tells it to disable logging for that database. I'll try to look for it this week. I thought I had it saved in a text file somewhere on my server.
 

Added: December/29/2008 at 12:06pm | IP Logged

Found it.. or at least this should be it..

Change the databasename value to match yours and run this agaisnt your database just like you would a query... you'll probably need to run it logged in as a SQL Server User with enouigh permissions to make such a change but I am sure you'll figure that out

ALTER DATABASE databasename SET RECOVERY SIMPLE

BACKUP LOG databasename WITH TRUNCATE_ONLY