I'm planning to move my SysAid server installation to a new server. It's going to be a VMware virtual machine running MS Server 2008 R2 and I'm going to use Veeam Backup and Replication 6.1 to backup the entire virtual machine. I'm currently using Derby database but it doesn't have VSS writer so there is a risk of database corruption during the backup. I have two possible solutions:
1. Use task scheduler and a script to stop SysAid server service before running the backup job. After backup is completed use post-backup script to start SysAid server service.
2. Convert database to VSS aware database = MS SQL. Does it cost something or is it included to support (I have Pro Plus version of SysAid.)
There must be others using similar configuration. How are you managing your backups? Any other ideas?
Since you already pay for support, they will do that for you for free, but it will take some time for them to do it (ours was converted years ago, and if I recall correctly, they were able to convert it overnight.)
We're running our sysaid stuff in a virtual machine and using Replay to back it up.
I recommend you move to MSSQL or any other DB like MySQL or Oracle.
If you have a valid support contract migrating your DB from derby to any DB of your choice if free of charge of curse.
Please contact your account manager to schedule the migration.