Can I change the recovery model on my Forecast 5 database .log file from Full to Simple?

Can I change the recovery model on my Forecast 5 database .log file from Full to Simple?

Question:

My .log file for the Forecast 5 database has grown to a significantly large file. Can I change the recovery model from Full to Simple?


Solution:

Forecast 5 uses Full recovery model by default to allow you to be able to restore from the log file should anything go wrong.


However, if you have a solid backup routine, then there is no reason you cannot change to a Simple Recovery Model.


See this article here that explains the differences in recovery models

    • Related Articles

    • Update the config file - point Forecast 5 to a new server or database.

      If you have a network license and you wish to store the Forecast 5 database on a server, you will need to update the config file to point to the correct server and database. On the server, go to this path: C:\ProgramData\Forecast 5 Ltd Edit the file ...

    • SQLException: Failed to update database... because the database is read-only

      Issue/Error: When opening Forecast 5, you are receiving an error: Forecast5 cannot continue because of an exception occured: SqlException. Failed to update database "[database name]" because the database is read-only. Forecast 5 will fail to open. ...

    • Forecast 5 Support Policy

      The annual subscription includes the provision of support to an end user, access to the online training videos, continued use of the product and access to updates and releases.  You have access to the Forecast 5 Knowledge Base, available ...

    • Database creation: NullReferenceException

      Issue: When trying to create a new database, you are receiving the following error but the database is still created in SQL:  NullReferenceException Object reference not set to an instance of an object. Cause: This is caused by attempting to connect ...

    • AUD forecast defaulting with NZD details

      Issue/Error: When creating a forecast, and selecting AUD, the forecast still populates with NZD defaults. Solution: Below is an SQL database that will generate AUD template. To restore this, follow the steps below for your license: A – Single ...