Automating SQL database backups

Automating SQL database backups

Because Forecast 5 is not yet a cloud solution and currently uses an SQL database to store your forecasts on either your local PC or server, it is important that you arrange for your SQL database to be backed up.

If you use the standard local database, your forecasts are being stored C:\ProgramData\Forecast 5 Ltd\Data.
You can either backup this folder or backup the database using the instructions below.

Here is a link to Microsoft's website on how to schedule back ups so you can arrange for this. 

If you have IT people, they would be the best to set this up as they will then be able to recover and restore your database.

    • Related Articles

    • Taking a Back Up through SSMS

      To take a backup using SQL Server Management Studio: Download SQL Management Studio (on both computers) https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms   Open up the SQL Management Studio. Connect to the SQL ...

    • How to upgrade your Forecast 5 database to SQL Express on your local PC

      It is common for larger users of Forecast 5 to upgrade to SQL Express from the standard LocalDb. Upgrading to SQL Express or higher is strongly recommended for multi-user sites, licenses with consolidations and integrations, and network/server ...

    • 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 ...

    • 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. ...

    • Cannot open database "...." requested by the login. The login failed.

      Issue: When trying to open Forecast 5, you are receiving the error below: SqlException Cannot open database "Forecast5V3_2018" requested by the login. The login failed. Login failed for user 'Navsoft\JohnDoe'. at ...