Free Accounting Backup / Restore Function is used to protect your data from missing or damaging. It compresses the data into a
compact file that is smaller than your database file. It is recommended to backup all the data on a regular interval (monthly/quarterly)
or after the entry of important data at other location than Free Accounting folder. This location should be shared. After you backed up the data you can easily restore it.
Note: You may receive the following error message when opening the Backup / Restore Accounting Database
window. Your SQLServiceAgent service is not started. To start it, use the steps provided in the Cannot start services: MSQLSERVER and SQLSERVERAGENT online
knowledgebase article.
Restore the database
To restore the data do the following:
- Close all Free Accounting child windows.
- Choose File on the Free Accounting main menu.
- Select Database / Backup/Restore Database option.
- Click the Restore Now button on the Backup/Restore Accounting Database window.
If some child windows are still opened you will see the following error message. Close all the child windows, open
the Backup/Restore Accounting Database window again and click the Restore Now button.
If you are connected to the remote SQL Server and want to restore the database located on your computer
and selected the backed up file from the local folder (c:\folder_name\file.bak) and not from the folder located on a
network (\\computer_name\folder_name\file.bak), the following error message will appear. Navigate to the network folder
and select the backed up file from there.
- The Restore operation window will appear.
- Click the Yes button if you want to restore the backed up database under the name of any database.
The Restore Database window will appear. Select the name of the database you want to restore from the drop-down.
Select the backed up file for the database by clicking on the Browse button and selecting it from the list of the
backed up files. Click the Open button.
- Click the No button if you want to restore the database under the name of the database you are logged in currently.
The Open Backup window will appear. Select the backed up file from the list of available ones to restore the
database and click the Open button.
- The Confirm window will appear. Click the Yes button if you want to proceed with the restore process.
Click the No button if you want to cancel it.
If there are any users connected to the database you want to restore, the message with the list of connected users will
appear.
Click No to cancel the restore process. Click Yes to disconnect the users and proceed with the restore
process. The users connected to the current database will receive the following message:
- If you agreed to the previous message the Database Restoring window will appear. Click the Close
button to complete the restore process.
- You have completed the restore of the database successfully. Click OK to restart the Free Accounting
application.
To open the restored database, you should use the login and password that you used for working in the backed up database.
|
|
