Tips For Database Backups

Save your database.
We really recommend creating backups of your SysAid database, even as often as every day. This can be quite simple to do, and it can save you a lot of hassle. Here are some instructions of how to save your SysAid database, in the case of a built-in Firebird or an embedded Derby database.

There are two ways to backup the built-in database.

1. Warm (online) backup:

Use the gbak program in the firebird\bin directory to backup without stopping the database:

gbak -t -v -user sysdba -password masterkey "localhost:C:\Program
Files\SysAidServer\firebird\SYSAID.GDB"

2. Offline backup:

Step 1: Stop the "Sys Aid Server" service. How to locate ...

and stop services depends on your operating system. In Windows XP, for example, find your services under Control Panel " Administrative Tools " Services.

Step 2: Stop the "Firebird Guardian" service.

Step 3: Backup the entire database file (SysAidServer\firebird\SYSAID.GDB).

Step 4: Start the "Firebird Guardian" service.

Step 5: Start the "Sys Aid Server" service

To backup a built-in Derby database :

Step 1:
Stop the "Sys Aid Server" service.
The way to locate and stop services depends on your operating system.
In Windows XP, for example, you will find your services under the Control Panel Administrative Tools Services.

Step 2: Backup the entire directory located under SysAidServer\root\WEB-INF\DB.


Step 3: Start the "Sys Aid Server" service.

To create a backup of an external database such as MySQL, Microsoft SQL or Oracle, please consult your DBA.