Thursday, August 19, 2010

SQL Transaction log growth whilst in Simple mode

Have you ever wondered why the SQL transaction log continues to grow even though the database is running in Simple recovery mode? I have noticed this a few times before but never really looked into it too much as I have always had the space to allow the log to grow and then reclaim the space later however I was recently working on a VMware Virtual Center instance and had very little disk space so I ended up learning something new.

This post has moved -

No comments: