Where do you store your backups? Do you store them in the local folder or somewhere in the cloud? How long does it take to make SQL Server database backup and then to move it to, for example, Dropbox? Why not just simply use SQLBackupAndFTP for automatically making scheduled SQL Server backups to Dropbox?It makes your life much easier.
How to Backup SQL Server to Dropbox
Follow this simple steps to create SQL Server backup job which will make scheduled backups and send them to Dropbox.
- Start SQLBackupAndFTP, connect to the SQL Server and go to the “Select Databases” section. Click the gear button and tick those databases which you are going to backup.
- To choose a place where your backups will be stored, go to the “Store backups in selected destinations” section, click the plus button and select “Dropbox”.Press “Authorize” to open the browser and allow SQLBackupAndFTP to access Dropbox.Specify the folder where SQL Server backups will be stored and press “Test” to check Dropbox connections.
- Finally, create a backup schedule. To do it turn on “Schedule backups” option and click the gear button to find “Advanced backup schedule”.
- Now everything is ready to start making backups. All your backups will run according to the schedule, also, you can run a backup immediately by clicking “Run Now”.
As you can see it takes only a few minutes to create a SQL Server database backup job which will do all work for you.