Follow by Email

Thursday, 8 October 2015

SQL Server Reporting log LDF grown too big

Found out the SQL Server Reporting Services (SSRS) log database ReportServer_log.ldf file was eating up all disk space 86GB. Found out some forum , this is because by default the Maximum File Size setting is set to 2TB and no Maintenance Plan is active to shrink the file.

Step to shrink the file and how to reduce logfile size.

  • Start SQL Management Studio
  • Expand Databases then select the ReportServer database. Right Click on it, choose Properties.
  • Select Options, then change “Recovery model:” from Full recovery to Simple.

image

  • Right Click on the ReportServer database again and choose Tasks, Shrink then Files.
  • Under “File type” select Log and click OK.

image

The ReportServer_log.ldf file should now significantly decreased in size in my case from 85GB down to 2MB

No comments:

Post a Comment