You can use Bulk Recovery Model .

Alo you can create alerts with job steps when you log becomes full , it can truncate it then shrink it .

You...

hi ...

1) run dbbcc checkdb

1.1) run dbcc checktable statements

2)Get rid of the second transaction log , the second one only comes into play when the first one is full...

hi..

Yip read the upgrade docs and white papers .I wouldn't say it is pretty painless , cause I have experienced majour hasles with sql 6.5 to sql 2000 . What...

Just a tip never use auto shrink , cause you will not know when SQL will shrink the database , it is actually recommended by microsoft that auto shrink...

Why don't you run a profiler trace on the stored procedures that the web app is executing , maybe you will find something there . Also look at your stored...