cancel
Showing results for 
Search instead for 
Did you mean: 
ChrisBeech
Premier Partner

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

 

0 Kudos
1 Reply
Highlighted
FreeFlow Production Workflow Moderator DavidU54339-XRX
FreeFlow Production Workflow Moderator

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.

0 Kudos