Shrinking my database log file does not work. After 2 and half week of search i finally ended up on the following query :
SELECT name, log_reuse_wait_desc FROM sys.databases
My specific database does show
REPLICATION as the cause. How does someone shrink the LDF to reasonable size ?
What i have :
- MDF ~13 GB
- LDF ~1.8 TB (non sense)
- Full recovery mode
- Full backup every morning 5 am
- Transaction backup every 15 min
I have 1 replication for 2 table of 0.24 mb and 1 of 0.14 mb so not even 500kb total. Transaction every 15 min total size over a day average 1 gb so i do not see any reason for log to be bigger than DB size in that case.
Shrink file doesn't work and i am getting close to major problem that my 2 days backup with current log uses 5.9 TB out of 6 TB for a 13 GB actual DB size.