问题描述:

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.

相关阅读:
Top