isnt redundant server sync with duty server time to time without fail?
why do you require manual sync to backup?
It's not manual. It has always been automated.
In the past it was programmed such that the database was copied every 24 hours.
The problem with this is that if the database ends up corrupted just before it is copied, then the copy would also be corrupted. I will always have one more copy but that would a week or so old so if I lose the current database, I potentially lose up to a week's worth of data.
With this new schedule, I will always have 7 copies ranging from 1 day old to 7 days old so if the database crashes, I would lose at most 1 to 2 days of data.
The downtime last night was because I was configuring this schedule and creating a fresh copy.