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 how ...

The databases and their log files reside on a separate disk subsystem, but "errorlog" sits under C Program Files\Microsoft SQL Server\MSSQL\LOG According to explorer it is 3.4Gb, but checking the file ...