Hi folks,

As a novice on SQL Server, I did a default installation of Express 2008. After a while, C: drive got full because the transaction log had unrestricted growth.

First thing I did was to find out how to get some free space back. I discovered shrinking the log file, and it dropped from 15GB to 40MB.

Questions:
a) the Shrink file dialog showed 99% free; why did the file keep growing if it...