V3.5 14/08/19
UD0089
Page 718
This Document is uncontrolled unless over stamped "CONTROLLED DOCUMENT"
3.22.2
SQL DATABASE BACKUP
It is extremely important to take regular backups of the Traka database in case of disk or file corruption or hardware
failure. Unlike with an Access database, the SQL Server backup process currently cannot be automated and so a
regular manual backup must be taken.
It is strongly recommended that you incorporate Traka into your disaster recovery plans in case the worst happens.
The Traka SQL Server Manager can be used to make a backup of the selected Traka database...
1.
Click SQL Server Manager from the Traka program group in the Start menu to open the Traka SQL Server
Manager:
2.
Click on Backup Database.
3.
Check the Backup Filename is correct and alter if required.
NOTE:
The backup path is relative to the SQL Server and NOT the local machine that the Traka SQL
Server Manager is running on. Also the local system account on the SQL Server needs full NTFS
permissions on the directory that the backup is to be saved to.
4.
Click on Start Backup.
5.
When the backup has completed a message will show, click on OK.
6.
Click on Close.