This question already has an answer here:
I have a database with a memory optimized table and table partitions. The log file is over 300GB in one
.ldf file, and another 40GB in another. I have tried shrinking the db, files, log
DBCC SHRINKFILE ('dblog' , 0) DBCC SHRINKFILE ('dblog' , 0, TRUNCATEONLY)
Nothing seems to shrink the log and it's very large. Each day it gets bigger and bigger. Nothing seems to shrink it. Any advice?
- I have all the service packs already installed.
- The database is in SIMPLE recovery mode.
- I use the maintenance wizard to backup differential nightly and full on Sundays.
log_reuse_wait_descfor the database is
- It is definitely using the
- A manual
CHECKPOINTdid not change anything.