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

javascript - jquery or ashx not working -

opencv - DataType<cv::detail::deriv_type>::depth what is it used for -

python 3.x - Mapping specific letters onto a list of words -