rob.lewis 86087 (1/30/2015)
If you have a 20gb transaction log file in simple a recovery model
A full back up is runA check point is made
The transaction log off the back of that is truncated
The log file still remains at 20gb on disk
If the first thing to run is a 100mb transaction it will start to fill the empty the log file as apposed to increasing it to 20.1gb?
Yup, though the backup has nothing to do with anything in this case. A checkpoint occurs (runs regularly), the log gets truncated.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability