I have a SQL Server 2012 database with Simple Recovery Model.
The SQL Log file size was set to 20mb but when a full database backup is made, the size of the file is set back to 1mb.. why is that? is the default behavior?
In simple revovery model the log write has very low rate. So every time you take a full backup the engine figure out log is not critical and shrink it to 1mb.