Log file of test database bloating -- sql server (alternate)

sasrani NO[at]SPAM boathouse.com
10/6/2004 7:18:35 AM

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

Simon Hayes
10/6/2004 4:27:13 PM

[quoted text, click to view]

This might be useful:

http://support.microsoft.com/default.aspx?scid=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

sql server (alternate) : Log file of test database bloating