Answer by TimothyAWiseman ·
Answer by Shawn_Melton ·
Answer by Fatherjack ·
If you are transferring over the internet and security is an issue then personally I would opt for a 3rd party product (I use RedGate SQL Backup https://www.red-gate.com/products/dba/sql-backup/) as they will compress, encrypt and transfer files for you all in one process, you simply decide on compression rate, encryption strength, alternative location and schedule. Job Done.
[Dislosure: I am a Friend of RedGate so have a certain bias towards their products. At work however we pay for our licenses and I think they are worth the cost in the assurance they give]
Answer by Sadhu ·