Taking a Back Up through SSMS

Taking a Back Up through SSMS

To take a backup using SQL Server Management Studio:

  1. Download SQL Management Studio (on both computers)

    https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
     

  2. Open up the SQL Management Studio.

  3. Connect to the SQL server (for localdb, the server name is (LocalDB)\MSSQLLocalDB)
  4. Go to your Forecast 5 Database, by default, named Forecast5V3_2015.
  5. Right click on the database, scroll down to Tasks, select Backup.
  6. Take the backup.
  7. Save the back up somewhere safe.
See this article for Automating Your Backups.

    • Related Articles

    • Bank Transfer Causing Unbalanced Balance Sheet

      Issue: The bank transfer does not appear to be transfering from the main bank account to the second bank account.   Solution: Delete the transfer from the second back. Re-enter.

    • Additional Years Not Appearing On Reports When Consolidating

      Issue: You have created a multi-year consolidation and the additional years are not showing in the forecast or reports.   Solution: Once you have created the consolidation, open a base forecast. Alter a figure to allow calculation. Head back to the ...

    • Activation buttons not showing

      Issue: I cannot see the Activate Online Now buttons. Solution: Close Forecast 5. Ensure the screen resolution is set to 1920 x 1080. Re-open Forecast 5. The buttons should now appear. If this did not work or the resolution was already 1920 x 1080, ...

    • Hotlinks not holding

      Issue: When hotlinking to a spreadsheet, the figures pull through fine. But when exiting out of Forecast 5 and coming back in, the hotlink is no longer holding. Cause: This can be due to punctuation marks, e.g. ' (apostrophe), , (comma), etc. Because ...

    • Moving Forecast 5 from one PC to another.

      If you have a Single Computer License and you change computers, there are two ways to do keep your forecasts: First follow the process to deactivate your license in this article How To Deactivate Your License (forecast5.com) Method 1: For those using ...