Hi Visvanath,
Our reason to move the automated backup to the database server was the NFS share we use to connect to our database server.
Once we moved the automated backup to the database server it ran much faster and more stable. If you have Moodle on one server,
you could also try to run the automated backup outside the Moodle cron with a bash script that is started by the Linux cron. Our
automated backup runs at night until the early morning.
Our reason to move the automated backup to the database server was the NFS share we use to connect to our database server.
Once we moved the automated backup to the database server it ran much faster and more stable. If you have Moodle on one server,
you could also try to run the automated backup outside the Moodle cron with a bash script that is started by the Linux cron. Our
automated backup runs at night until the early morning.