How do I identify and fix the cause of transaction log growth on SIMPLE recovery model databases?
- by Stuart B
I recently upgraded our SQL Server 2008 installations to service pack 2. One of our databases is on the simple recovery model, but its transaction log is growing extremely fast.
The path I'm currently investigating is that we have a transaction somewhere out there stuck in active state. Here is why:
select name, recovery_model_desc,…