Why does my transaction log growth? simple and clear!
Howdy people! Ready for another post? I'm sure someone will have reported this to you: "Hey we have a problem! we have a database whose transaction file has grown and is now taking up several gigabytes!" Today we will see why it happens But i warn you! In order to understand completely the continuous you need to read this post: The WRITE AHEAD LOGGING mechanism You need infact to learn how data are passed from the log to the data file. The post of today can be considered as a continuation of it. Go! Hey, the transaction log of my database is growing! A little basic concept Each database consists of two o more physical files. One or more files with mdf file extension are called data file because it contains data. One file with ldf file extension that's called transaction log file . This transaction log file contain data not yet committed For example, if start a transaction and then i run an insert, before the commit, data are stored in transaction log (ldf...