We are using SQL Server 2012 standard Edition (SP4)- 11.0.700.0(x64) (Build 14393)(HYpervisor).
Data File Size = 171 GB Log File Size = 106 GB
When I queried
sys.databases to see the
log_reuse_Wait_desc it is always
LOG_BACKUP- even right after log backup!
When I run
DBCC SQLPERF(logspace) I see "Log space Used %" is less than 1%.
DBCC loginfo returns 773 which is high.
FYI- This database is not involved in Log Shipping/replication/mirroring. The recovery model for this DB is Full and log backups are taken every 30 minutes. I know log backups are happening as I checked from
This database had % autogrowth setting on log file until last week. I changed it as part of config change.
How do I find why the
log_reuse_desc is returning
I would like to explore some options to reduce the log file size on the disk. (I know it is a bad bad thing to trucate and shrink the log file, but at this point I would like to know my options available). Can someone please suggest a graceful way to do this.