开发者

Determining what is causing massive log file growth on an inactive SQL 2005 DB

I have a SQL DB in a test environment that is the back end datasource for a test web site. There is no activity on the website (be开发者_运维百科cause it is in our test environment), but every couple of days the DB log files grow extremely large, causing issues with backups, etc.

This is a test environment so there is no activity that we don't have control over. Why are the logs growing at all? And why so large?

I am looking for some tips on how to track down what is causing this log growth on an inactive site/DB.

I have looked for open transactions using DBCC OPENTRAN with the result of no open trans.

Any other ideas?


Do you have any jobs running on a timed basis such as backups or optimizations? Doing a full rebuild of indexes as part of the maintenance job can cause the log files to be larger than expected (among other things - that is one of the most common).

Places to look in SSMS for jobs:
Management - Maintenance Plans
Management - Legacy (if you were using older versions of SQL at some point)
SQL Server Agent - Jobs

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜