Show/Hide Toolbars

DBA Help

One person at your company should be designated as the system administrator and given the following responsibilities:

Apply all product updates in a timely manner

In order to receive optimal support and benefit from hot fixes and software enhancements and new features, always apply product updates in a timely manner.  We only provide programming fixes to the current product build and not to past versions.. Our support and software maintenance model is based on the premise that all customers are on the current build.  

Use the Backup Manager to schedule daily database backups  

Use the Schedule Backups process within the Backup Manager to schedule automatic daily backups of your registered databases, which is your Main Company, your System database, and any other registered companies you may have licensed.  

Incorporate database backup files in your daily general backup    

You will continue to make a general daily backup of all the critical data folders on your server, not just for DBA but for other applications as well.  The general daily backup should incorporate the (drive letter)\ProgramData\DBABackup folder, which contains your database backup files.  

Optimize your database on a quarterly basis

To keep your database lean and efficient, run the Backup and Restore process within the Backup Manager utility on a quarterly basis.  

Manage users and security

Users must be added and inactivated as needed and given menu security permissions.  

Do not allow database updating or editing  

The system administrator must not allow any user or third party to update or edit the Firebird database.  Not only is this expressly prohibited by the DBA software license agreement, but tampering or alteration of database tables and records can cause data corruption, interference with programming processes, support issues, and result in system malfunction or failure.   "Read-only" access to the database via any ODBC reporting tool is allowed.   You may also freely extract data using data views or data export, but any updating must only be done by the DBA software program.