I noticed the size of our SQL Forms Database log file is growing quite large (almost 10GB). I know I can set a limit in SQL but is there a place in forms where I can set a limit? Is there a way to reduce the size?
Hi Paul,
Yes, it's possible to manage the size of the log file. However, I'd recommend that you perform regular backups of your DB in order to ensure the Log file does not continue growing without being kept in check. A backup normally truncates the log file and regular backups will keep this in check.
Is there a particular reason you wish to manage the log file size? If not, I'd ensure backups are in place and leave it as is.
Cheers
Sheldon
The other thing to think about is "What happens if I do have a corruption in the middle of the day. Do I have someone on staff (or someone on call) who can recover SQL from the logs, and the time to do it? Or do I simply make a backup on a daily (or more than daily) basis and restore that backup because what was done since the last backup can be replicated?"
Recovering using transaction logs is not overly difficult but can be time consuming because you are playing back everything that happens and it can take much longer. This is especially true of the log files have grown to be larger than your actual db.
If the answer is "just restore from last backup" then you probably don't even need to be writing to the log files - you should be putting your sql database in simple mode.