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 |