SQL Errors
      Back to home
      1. INTERNAL - Bepoz Help Guides
      2. Troubleshooting
      3. SQL Errors

      SQL - Shrinking a log file (LDF)

      Overview

      Problem / Symptoms:

      There are cases where the SQL LDF log file outgrows the size of the MDF file, which could result in suspect DB and also cause Smartcontroller not to run. ​​​​​​​

      Diagnosis:

      Solution / resolution:

      Login into SSMS

      • Navigate to Databases

      • Rightclick on the Database you want to shrink the LDF (log File)

      • Select Properties 

      • Select files 

      • Under File Type - LOG reduce the size to 25% of the size of the MDF (Main Database File) 2000/25% = 500MB

      • Click OK