troubleshooting Question

Sharepoint_Config - Transactional LOG Full

Avatar of Solvesystem
SolvesystemFlag for Brazil asked on
Microsoft SharePoint
3 Comments2 Solutions833 ViewsLast Modified:
Anyone knows why sharepoint_config transactional log is grow up everytime and goes to a FULL state fast.

I´ve following this script, and for the moment the log is growing down, but in 15 days more or less, the log goes to 15 GB, even the sharepoint doesn´t have almost nothing new or changed.

###SCRIPT#####
 
USE SharePoint_Config
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE SharePoint_Config
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (SharePoint_Config_log, 1);  -- here 2 is the file ID for trasaction log file,you can also mention the log file name (dbname_log)
GO
-- Reset the database recovery model.
ALTER DATABASE SharePoint_Config
SET RECOVERY FULL;
GO

#######################################################

How to fix this ?

Thanks,
Leandro
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros