Showing results for 
Search instead for 
Do you mean 
Reply
Premier Partner
Posts: 22
Registered: ‎06-03-2014

FFCORE Database Logs

Good morning, 

 

I have a developing issue with the size of the database logs for the OAP Databases on the SQL Server. I am running a full version of SQL2014, and have a log for one server that is now over 75GB, and filling up the partition allocated for the logs.

 

I have looked for some documentation on the maintenance of these log files from a FFCore perspective, but can't seem to find anything. Am I good to just delete these files? Is there a function to clean them or recycle them when they grow too large?

 

Looking for some guidance please. 

 

Chris

 

Highlighted
FreeFlow Production Workflow Moderator
Posts: 10
Registered: ‎02-13-2017

Re: FFCORE Database Logs

Try the following:

To control the size of the logs for a database:

 

  1. Launch Microsoft SQL Server Management Studio
  2. Locate your database and right-click on it. Select Properties.
  3. Click on Files section
  4. Locate the LOG FILE line.
  5. Change the Initial Size to: XXX
  6. Locate the Autogrowth section and click on the ellipse (...)
  7. Uncheck "Enable Autogrowth". Click OK.
  8. Click OK to make the change.

 

Note: You can also set a maximum log file size in the "autogrowth section".

 

See attached png.