System Center & Automation

SCCM Reporting Database Log File Size

S

Reporting Server DB log file may increase dramatically in time in SCCM. If you dont take preventive actions, you may have service interruptions.

Before you do any action, first check the actual size of the Report Server log file. The easiest way to locate your files is to use SQL Management Studio.

Right click on the ReportServerDB and choose properties and select Files tab. Locate the path of the log file.

Open the directory.

The size of the log file is pretty big.

In order to reduce the size, we will do the Shrink operation.

Right click on the ReportServerDB and from tasks choose Shrink >> Files.

Select Log from File type and click OK.

Check the same log file. You may see that the size is reduced. If the size hasn’t been reduced then make sure that you have enough space on the Hard Disk. After allocating more space, try the same operation again.

In order to limit the Auto Growth of the Report Server DB log file, right click on the ReportServerDB and choose properties and select Files tab.

The default Maximum File Size is set to 2 TB. Change it to something more realistic according to your disk size.

By ozgeozkaya
System Center & Automation

Categories