SCCM Reporting Database Log File Size

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.

Related Posts

SCCM Update Stuck Downloading State

In order to reset the stuck download of SCCM Service Update, first you need a copy of the update reset tool which comes within the SCCM download…

SCCM 1902 Upgrade

In-console upgrade of SCCM 1902 is available. As best practice, it is always recommended to run the prerequisite check before you install the upgrade directly. \Administration\Overview\Updates and…

SCCM Site Back-Up Failure

SCCM site back-up is one of the essential back op options. Even your environment is stable, you may receive alerts in smsbkup.log as below: Cannot find the…

SCCM 1810 Upgrade

In-console upgrade of SCCM 1810 is finally available. As best practice, it is always recommended to run the prerequisite check before you install the upgrade directly. The…

SQL 2016 upgrade for SCCM Server

In this post, I will show how to upgrade the SQL server of SCCM from 2012 S3 to 2016 SP1. Requirements: SCCM server with min SQL 2012…

Windows 10 Servicing Update Failed

When you are upgrading Windows 10 using Servicing Feature in SCCM, you may get failure as below related to the incompatible software. Because the UI is not…