I have an SQL database which has a log file.
This log file will be saved in a different hard drive than the actual data.
Now today we found out the LOG hard drive was full. After Ignition had trouble getting to the SQL database.
I have found out in the properties if you set the database recovery mode to “Simple” you can shrink the database log file manually. Which I did and this worked.
Now in the properties I also found an option called “Autogrowth Max file size” which was set to 2.000.000MB (2.000 GB) where my harddrive was only 49.9 GB.
I changed this to 40.000 MB (40 GB). My question is what will happen if we reach this 40.000 MB.
Will Igntion have trouble again or will it auto delete the logging at the beginning and keep logging?
Or is there another way to make sure logging files don’t reach their max size?