FFCORE Database Logs

[DavidU54339-XRX]

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.

[ChrisBeech]

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