How to Backup SQL Server to Dropbox

How to Backup SQL Server to DropboxHow do you make your SQL Server database backups, with the help of T-SQL Commands, by using SSMS, or in any other way? Do you prefer to store your backup in the cloud, say, Dropbox? How much time do you spend every day to make your database backup and send them to Dropbox? In this article we are going to explain how to backup SQL Server to Dropbox with the help of SqlBak in just 5 minutes.

How to Backup SQL Server to Dropbox

To create a new backup job go to your Dashboard page and press “Add new job”, then select “Add backup job”. How to Backup SQL Server to Dropbox (job)

Now, let’s create a simple backup job. Choose the computer where SQL Server is located and then check for SQL Server connections. After that press “Continue to job settings”.How to Backup SQL Server to Dropbox (connection)

At the Select databases step, select SQL Server databases which you are going to backup. How to Backup SQL Server to Dropbox (databases)

At the “Store backups in selected destinations” step you need to add destination where your backups will be stored. To do it press “Add backup destination”.How to Backup SQL Server to Dropbox (add backup destination)

In the Add destination window select “Dropbox”.How to Backup SQL Server to Dropbox (Dropbox)

Press “Authorize” to open the browser and allow SqlBak to access Dropbox. How to Backup SQL Server to Dropbox (Authorize)

Select a folder on your Dropbox account and check your connection by pressing “Test”, and press “Save & Close” to apply new settings. How to Backup SQL Server to Dropbox

The last step of the necessary backup job settings is to create a database backup schedule. To do it press “Schedule backup (full, diff, tran log)” section and then click “Show advanced backup schedule”. How to Backup SQL Server to Dropbox (schedule)

Don’t forget to press “Create” to save your backup job. How to Backup SQL Server to Dropbox (Create)

Now your backup job is ready, all backups will be made  according to your schedule and then sent to  Dropbox. Also, you can set up more different settings like Compression and Encryption, E-mail notifications in case of failure or success, add some local folders to backup or specify Custom scripts. And this is not the exhaustive list of benefits SqlBak offers.

[Total: 2    Average: 5/5]

Leave a Reply

Your email address will not be published. Required fields are marked *