Reducing LDF size in SQL Server 2008 R2

  • Open SSMS
  • Right click the database in question and select ‘Properties’
  • Go to “Options” on the left
  • Change the line “Recovery Model:” from Full to “Simple” and hit OK
  • Take a full backup of the database
  • Right click on the database again, go to Tasks – Shrink – Files
  • Under File Type: select Log and click OK
  • Take another full backup of the database

Any comments or questions? Get in touch here or Email me at [email protected]