0

My database log file is so big(400 giga) and data file is (50 giga) My recovery method is simple and backup plan is daily full backup Log file is configured to auto growth. I checked open transactions, this the output enter image description here I tried to solve it but I can't. Thank you

6
  • 2
    What does the query SELECT log_reuse_wait_desc FROM sys.databases WHERE [name] = 'YourDatabaseName' show?
    – J.D.
    Feb 12 at 5:48
  • Do you have Change Data Capture enabled?
    – Hannah Vernon
    Feb 12 at 13:36
  • @J.D. 'REPLICATION' Feb 12 at 17:06
  • @HannahVernon no, it's disabled Feb 12 at 19:50
  • @AbdelrahmanMamdouh are you using Availability Groups or Replication?
    – J.D.
    Feb 12 at 21:08

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.