AnsweredAssumed Answered

Offsite backups

Question asked by nolak37 on Jul 6, 2012
Latest reply on Jul 6, 2012 by nolak37


Offsite backups


Is there a way I can have 2 copies of a database on multiple locations and have everyone connect to one to work on, then have the data replicated to the other?

I want to have little to no down time in case of an emergency, I think ill set up the DB on a server with RAID 10 and plugged into a UPS and set up backups every 5-10 minutes but what if the power supply or motherboard crashes, I want to have the second DB so the users can simply log onto the remote copy and continue to work.

I thought of making a script that would import the information from each table and set the import as update matching records in found set and just looping the script so the information is always up to date and the backup file is missing little to no info in case of a crash.

Would this work?