@Aum Currently the only supported method to backup the Connect database is via the administration console by using the export functionality. This method currently can't be automated or scheduled. For information on backing up and restoring Connect please see the help documentation at:
https://help.alteryx.com/connect/current/Administration/DBBackup.htm