We help IT Professionals succeed at work.

SQL Server Reports SharePoint Config Log is Full

aitg
aitg asked
on
High Priority
22 Views
Last Modified: 2020-03-24
Dear Experts:

How to interpret the following alert, and what action(s) to take?

SQL Server: DB (SharePoint_Config) Log Space Util
Test Type: wmi
Warning Threshold: n/a%
Critical Threshold: 99%
Current Result Value: 100%

Thanks,

Austin
Comment
Watch Question

Database Analyst
CERTIFIED EXPERT
Commented:
On your SQL Server, open the SQL Server Management Studio.  Connect to the local SQL Server.  Right click SharePoint_Config -> Properties -> Options.  Change Recover Model from Full to Simple.  Click OK.  Right click SharePoint_Config, go to Tasks -> Shrink -> Shrink Files.  Select a File type of Log, then Shrink.

Author

Commented:
Thank you Icohan for your rapid response! Surely others will be helped by this solution, as well.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.