There is a client of mine that has two machines, one of which is the server where all the data in the database is stored, and the other is the box.
However, there is the customer's concern that something happens to the server that the data is saved somewhere on the internet. So I saw C # (which is made the application of the box) generate a ".sql" file every night with the backup of all the data from the database. And I send this ".sql" via FTP to a server of mine.
My big question is if the method I'm using is good, why do we notice that the more time passes, the larger the ".sql" file gets and the longer it takes to send the file to the FTP server. I would like to know if the method used is good and feasible or if there is something better.