A Tip for SysAid Database Backup & Restore

 
Author
Message
SysAid CEO
617
 
Hello All,

This June, we cover quite a serious topic in IT. As IT personnel, we all know of the horror of data loss without a recovery option.

That's why building a backup and restore plan for SysAid is absolutely crucial to successful implementation. At times, we encounter users who have lost all their data due to a lack of a robust backup and restore plan. Such faults can result in real damage to your organization, not to mention the negative affect to your IT department's service reputation.

The key to success is not only to backup your data, but to also test the robustness of your backup by trying to restore the data.

You can ensure your SysAid server is securely backed up using our simple SysAid Backup plan as detailed below.

Step One: Backup your data. For those using the Derby database, SysAid comes with internal backup capabilities as detailed below:

1. Access the Backup configuration under Preferences -> Integration -> Backup

2. Check the 'Enabled' box to activate this feature

3. Now select the list of users who will receive backup notifications and information about backup success or failure



If you are using an external third party database, you should ensure that you have standard backup processes in place.




Step Two: Now it's time to test your backup data restore. If you are using our internal database, we recommend the following:

1. Install a new SysAid server

2. Stop the service of the current server

3. Locate the latest backup copy in the backup directory (SysAidServer\backup). You will find a folder for each day of the week with the day number (from 1 to 7) as the folder name. Rename that folder to "db".

4. Take the renamed "db" folder from the backup and replace it with the database folder under the new installation (SysAidServer\root\WEB-INF\db)

5. Check that when uploading the new server, the information saved under the backup is indeed an updated snapshot of your information



Step Three: Confirm that you are receiving notifications every time backup is run, to ensure that you have a current, up-to-date backup.

Step Four: Schedule periodic restoration checks to ensure that the backup is still running (e.g. every month). Use Reoccurring Events, available in our Task and Project module, to open a Service Request based on a pre-defined schedule to remind you to check and restore.

Step Five: If you're not sure that your backup has worked, please consult SysAid Support. Also, if you observe unusual functioning in your SysAid, or errors in the log about database connection, contact us immediately, as you may have corrupted the database.

Without sounding the alarm too much this month, it is worth remembering that just a few minutes of your time now could potentially save you a lot more than just time in the long run.

Until next month, keep safe and restore.

Sarah
SysAider
2
 
Hi Sarah - Thanks for the tip. As I checked my system (v5.6.09 ), I noticed that the Backup tab settings of the Integration section were correct, but no backups had been made to the directory. I clicked on the RUN NOW button and it did make a backup to the directory. Why wasn't it making backups before?

Another question - In your article, you suggest the following ...

3. Locate the latest backup copy in the backup directory (SysAidServer\backup). You will find a folder for each day of the week with the day number (from 1 to 7) as the folder name. Rename that folder to "db".

4. Take the renamed "db" folder from the backup and replace it with the database folder under the new installation (SysAidServer\root\WEB-INF\db)

Don't you mean the reverse in step 4? Take the renamed "db" folder from the backup and replace the database folder under the new installation (SysAidServer\root\WEB-INF\db) with the renamed "db" folder.

Is it semantics across the ocean? If not, I don't understand how you would be checking the backup by overwriting it with the new installation db folder as you seem to be saying.


Jerald



This message was edited 4 times. Last update was at Jun. 05, 2009 07:06 PM

SysAid Wiz
2449
 
Hey Jerald Jackson.

Do you have a scheduled backup in the backup page?

I think you and Sarah used different words for the same procedure, which is basically taking the backup folder and place it instead of the existing "db" folder in SysAid. to restore it.

Regards.
Haim
Pushing IT forward
SysAider
2
 
Once I actuall went to the backup page and clicked run now and then save (without changing any of the settings) the backup magically started and is working! Perhaps this should be explained to everyone. I've included a picture of what the page looked like when it wasn't backing up. It looks the same now and it IS backing up - go figure - you guys should know.



As for the language and grammar choice in the Backup article by Sarah, I think it should have been reviewed by someone who speaks english as their first language. It should certainly be corrected if what you say is truly what she meant. It makes complete sense to me, but NOT what she said. There is potential here to completely confuse your users and possibly erase their data during a restore.

All that said - I still love your software! The price is right and the support is generally excellent. Everyone makes mistakes. Thank you for a GREAT product and great support!


This message was edited 1 time. Last update was at Jun. 08, 2009 08:40 PM

SysAider
23
 
Hi,

Please inform me how to take a backup of the cloud edition ?

Best Wishes,
Shariyaz Abdeen
SysAider
1
 
Hi all,

is it possible to backup the "Free Edition" via webinterface?
and if yes, where can i find the option?

If not is there any other way to backup the free edition Database?

Thx