I'm going to use SugarCRM and manage my data via SQL Server. I have a question regarding the data security, is SurgarCRM provide any backup solution? I need to backup SQL Server databases to Dropbox, any ideas?
Backups of the database are typically made on server side, there appear to be a couple solutions out there for SQL Server like:
How to Backup a Database using Management Studio
Adding a maintenance plan in Windows:
Maintenance Plan Wizard (Define Backup Database Transaction Log Task Page)
Or creating a automated batch script:
database - SQL Server Automated Backups - Stack Overflow
In my personal opinion I wouldn't advice to use dropbox for such highly confidential files, but rather create an encrypted storage in your internal network that you have full control over.
Hope this helps,
Retrieving data ...