SQL Server transaction logs A transaction log is a sequential record of all changes made to the database while the actual data is contained in a separate file.

I would like to know how transaction log size is managed. I now know after some reading that I can checkpoint the database in order to allow dirty pages to write from ram to disk.I also know now ...