DGH TECHNOLOGY SCANMATE FLEX - Database Management - SQL Server Backup; SQL Server Backup Procedure; Database Management - SQLite Backup; SQLite Backup Procedure

45
DATABASE MANAGEMENT—SQL SERVER DATABASE BACKUP
If a Client PC installaon was performed, an SQL Server database is used to store paent
records. Electronic records should be backed up regularly to prevent data loss. To backup the
Scanmate database using the Backup / Restore tool:
1. Open the Back Up / Restore window by selecng
File > Database > Backup / Restore.
2. Connect to the DGH Database Server by entering the
system administrator username and password that was
created when the DGH Database Server was installed
and clicking the [CONNECT] buon.
NOTE: This is the same username and password that
were created during SQL Server prerequisite
installaon.
3. Select the desired database to Back Up from the combo
box and select the [BACK UP] buon
4. Once the back up process has completed, a message
box will display the locaon of the backup le. It is
recommended that the backups be performed regularly
and stored in a safe locaon. Preferably, backup les
should not be stored on the same physical drive that
hosts the database.
DATABASE MANAGEMENT—SQLITE DATABASE BACKUP
If a Single PC installaon was performed, a SQLite database is used to store paent records.
Electronic records should be backed up regularly to prevent data loss. To backup the database
using the Backup / Restore tool:
1. Open the Back Up / Restore window by selecng File > Database > Backup / Restore.
2. The combo box shows the default locaon
where the backup le will be created. If a
dierent locaon is desired, click the […] buon.
A dialog window will open and allow a
dierent locaon to be selected.
3. Once the desired backup locaon is selected, click the [BACK UP] buon.
4. Once the back up process has completed, a message box will display the locaon of the
backup le. Click the [OK] buon. It is recommended that the backups be performed
regularly and stored in a safe locaon. Preferably, backup les should not be stored on the
same physical drive that hosts the database.
DATABASE MANAGEMENT—RESTORING AND TROUBLESHOOTING
Addional procedures for database management, restoring and troubleshoong are available in
the DGH Scanmate Installaon Guide.