Backups are critical to any application in which files, records and databases are updated on a daily or frequent basis. Within ArchiOffice/EngineerOffice, SQL database users need to implement a method as well as a regimented schedule for backing up their database. You have the following options for backing up your SQL database:
- SQL Internal Utility - If you have any paid version of SQL (excluding Express), then SQL has its own built-in backup utility.
- Via SQL Query - Run a standard SQL BACKUP Query. Note: This is not automatic.
- SQL Server Management Studio (SSMS) – A separate Microsoft tool used for managing SQL Server. It can be used to perform the backup process manually.
- (Recommended) SQL Backup and FTP – A shareware program that creates an automatic backup schedule. Click the link to get more information: http://sqlbackupandftp.com/
Note: There is both a free and paid edition of this utility; the functions you are allowed to use for free will suffice for backup needs and processes.
BillQuick 2017 and later has an additional SQL Backup feature that is available within the application. It requires a backup folder location to be specified in the Global Settings under Folders and this location must have full read/write permissions.