transactions - Sql Server log file size doesn't maintain size when full db backup is made -


i have sql server 2012 database simple recovery model. sql log file size set 20mb when full database backup made, size of file set 1mb.. why that? default behavior?

in simple revovery model log write has low rate. every time take full backup engine figure out log not critical , shrink 1mb.


Comments

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

javascript - jQuery show full size image on click -