当前位置: 动力学知识库 > 问答 > 编程问答 >

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

问题描述:

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.

分享给朋友:
您可能感兴趣的文章:
随机阅读: