DATABASE BACKUP AND MAINTENANCE

General Remarks

As all other databases, Synexsys databases need to be regularly backed up!

Backup and maintenance procedures are fully automated by the batch files provided. By closely following the procedure described below, in case of crash, you will be able to restore your databases without relevant losses. Also, from a performance point of view, you will be keeping your databases in optimum status.

Usage

The backup must only be made using file save.bat, found in the ..\synexsys inventory\server\bin\ folder, and can be scheduled in Windows.
   
file save.bat creates in folder ..\synexsys inventory\database a sxsi.gbk backup file that you must later store based on your own backup procedures. (See also the remarks below)
   
Once a week, launch main_db.bat* instead of save.bat, which can also be found in ..\synexsys inventory\server\bin\. (See also the remarks below)
   
File Maint_db.bat, like save.bat, makes a backup, but it also optimises the database to obtain the best performances possible. The initial database is renamed as sxsi_old.fdb.

* File maint_db.bat actions:

Important Remarks

Before programming backup procedures, make sure that the paths contained in the two batch files point to the correct folders. You may need to modify part of the paths before launching the backup procedure. If save.bat or maint_db.bat cannot connect to the database, you should modify them as follows:

save.bat:

Gbak.exe -b -ignore -user sysdba -password masterkey "..\..\database\sxsi.fdb" "..\..\database\sxsi.gbk"

becomes

Gbak.exe -b -ignore -user sysdba -password masterkey "SERVER_NAME:c:\program files\synexsys\database\sxsi.fdb" "..\..\database\sxsi.gbk"

maint_db.bat:

Gbak.exe -replace -ignore -user sysdba -password masterkey "..\..\database\sxsi.gbk" "..\..\database\sxsi.fdb"

becomes

Gbak.exe -replace -ignore -user sysdba -password masterkey "..\..\database\sxsi.gbk" "SERVER_NAME:c:\program files\synexsys\database\sxsi.fdb"

   
If an error arises in one of these batch processes, a backup.log file is created in ..\synexsys inventory\server\log\. If this is the case, "Synexsys Server" is not restarted.
   
It is extremely important to check everyday whether the procedure has been completed successfully (if the process was OK, no backup.log file is created).

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Last Update: 03.02.2005