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 - http://iunite.com.au/wp/blog/index.php/2011/09/sql-transaction-log-growth-whilst-in-simple-mode/
This post has moved - http://iunite.com.au/wp/blog/index.php/2011/09/sql-transaction-log-growth-whilst-in-simple-mode/
No comments:
Post a Comment