Link to home
Start Free TrialLog in
Avatar of Jim Metcalf
Jim MetcalfFlag for United States of America

asked on

Sharepoint_config transaction database getting large

Sharepoint 2013 on-site is what we are running.  I have a transaction log that gets huge on over the weeken.d  Sharepoint_config is the db.   the database is in simple mode so i dont know why it is doing this.  Does anyone know what jobs a normal sharepoint setup would run that would cause this datbase to get so large on the transaction file size?
Avatar of Walter Curtis
Walter Curtis
Flag of United States of America image

Does it shrink back down at all, or stay at the large size. Check to make sure that the backups are running correctly and that the transaction is truncated after the back runs successfully.

Good luck...
I will guess that it's the reindex job.
Do you have regular transaction log backups set for the SharePoint database?
Daily, but we don't retain very long.
SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jim Metcalf

ASKER

I turned off the indexing jobs and it still grew to a large state.  I am going to monitor.  I had to shrink it again.  I will continue to monitor
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you!