Wednesday, March 21, 2012

Log file of test database bloating

A test database that we used in one of our implementation pilots was
abandoned around 4 months back. The database when abandoned had a log
file size of less than 500MB. The log file has been steadily bloating
(just came to my attention) and has reached 8.5GB. The database has
not been used since abandoned 4 months back at 500MB. Considering the
fact that our live DB has a combined (data + log) file size of less
than 2GB I do not want to delete the database before exploring the
cause.

Any ideas? Thanks and appreciate your help

SQL Server 2000"Sanjay Asrani" <sasrani@.boathouse.com> wrote in message
news:26ae5f82.0410060618.352c931e@.posting.google.c om...
>A test database that we used in one of our implementation pilots was
> abandoned around 4 months back. The database when abandoned had a log
> file size of less than 500MB. The log file has been steadily bloating
> (just came to my attention) and has reached 8.5GB. The database has
> not been used since abandoned 4 months back at 500MB. Considering the
> fact that our live DB has a combined (data + log) file size of less
> than 2GB I do not want to delete the database before exploring the
> cause.
> Any ideas? Thanks and appreciate your help
> SQL Server 2000

This might be useful:

http://support.microsoft.com/defaul...kb;EN-US;317375

If you believe the database should not be in use, you might want to run a
Profiler trace filtered on that particular database to see what's happening.

Simon

No comments:

Post a Comment