Phoenix_uy
Reputation: 3294
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?
Upvotes: 0
Views: 57
Answers (1)
Amir Keshavarz
Reputation: 3118
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.
Upvotes: 1
Related Questions
- DBCC SHRINKFILE on log file not reducing size even after BACKUP LOG TO DISK
- Transaction log file size carry over when performing a backup on another SQL Server
- SQL Server log_reuse_wait_desc LOG_BACKUP, Transaction log full, does not become smaller after log backup
- SQL Server Transactional log backup is larger than full backup
- Transaction Log remains 60GB size, even after changing to Full Recovery
- Why Does SQL Server Log File Size Decrease
- sql server backup not truncating transaction log
- My log file is too large
- SQL Log File Not Shrinking in SQL Server 2012
- MSSQL2008 Backup of Log does not reduce log size