Log File Filling Up

Hi All,
We have a problem with our SQL server log file filling up. This problem has
got progressivley worse over a period of weeks. Probably easiest if I bullet
point the situation:
- Application is an ASP based website
- Site perviously ran fine for at least 18 months
- No recent code changes
- Started off happening once a week, got worse and worse, now the log file
fills in one hour
- Hosting company suggests this is due to incomplete transactions
- We've recently seen error messages reporting that the SQL server is
unreachable
- Even after doubling the log file size, the error occurs just as often
- Site stats show that the site has *not* become much more busy lateley
- Log file fills even when we avoid using anything that does alot of
inserts/updates
Any ideas what could be causing this? Is there any way I can test the SQL
server connectivity? I'm thinking it may be a bad network between the IIS
server and the SQL box, what elese should I be looking at? Any help will be
much appreciated!!
Regards,
Simon.
-
* Please reply to group for the benefit of all
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
* Search first, post later : http://www.google.co.uk/groups
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!Start by investigating with DBCC OPENTRAN and DBCC LOGINFO (see
http://www.karaszi.com/SQLServer/info_dont_shrink.asp)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
news:OQ0Ua1anGHA.4868@.TK2MSFTNGP02.phx.gbl...
> Hi All,
> We have a problem with our SQL server log file filling up. This problem ha
s got progressivley
> worse over a period of weeks. Probably easiest if I bullet point the situa
tion:
> - Application is an ASP based website
> - Site perviously ran fine for at least 18 months
> - No recent code changes
> - Started off happening once a week, got worse and worse, now the log file
fills in one hour
> - Hosting company suggests this is due to incomplete transactions
> - We've recently seen error messages reporting that the SQL server is unre
achable
> - Even after doubling the log file size, the error occurs just as often
> - Site stats show that the site has *not* become much more busy lateley
> - Log file fills even when we avoid using anything that does alot of inser
ts/updates
> Any ideas what could be causing this? Is there any way I can test the SQL
server connectivity? I'm
> thinking it may be a bad network between the IIS server and the SQL box, w
hat elese should I be
> looking at? Any help will be much appreciated!!
> Regards,
> Simon.
> --
> -
> * Please reply to group for the benefit of all
> * Found the answer to your own question? Post it!
> * Get a useful reply to one of your posts?...post an answer to another one
> * Search first, post later : http://www.google.co.uk/groups
> * Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
>