How to Backup SQL Server to OneDrive

How to backup SQL Server to OneDriveYou can make SQL Server database backups with the help of T-SQL Commands or with the help of SSMS and then move them to OneDrive. But how much time it will take you to do it? Use SqlBak and spend 5 minutes to create a backup job which will make schedule backups and send them to OneDrive. 

How to backup SQL Server to OneDrive

From the very beginning, you need to create a backup job, to do it go to the Dashboard page and press “Add new job” and then choose “Add backup job”. How to backup SQL Server to OneDrive (job)

In the “Settings of Backup” page choose the computer where SQL Server is located and check you SQL Server connections. Press “Continue to job settings” to continue the backup job settings. How to backup SQL Server to OneDrive (connection)

Tick all databases which you are going to backup How to backup SQL Server to OneDrive (databases)

Now select a destination where are you going to store your SQL Server database backups. To do it click “Add backup destination” in the “Store backups in selected destinations” section. How to backup SQL Server to OneDrive (add backup destination)

In the “Add destination” window choose “OneDrive” How to backup SQL Server to OneDrive (OneDrive)

Press “Authorize” to open the browser and allow SqlBak to access OneDrive:

 

How to backup SQL Server to OneDrive (Authorize)

Select a folder on your OneDrive and click “Test” to check your connection, do not forget to press “Save & Close” to apply all settings.

How to backup SQL Server to OneDrive (Test)

Press “Schedule backup (full, diff, tran log)” to set up backup settings, click “Show advanced backup schedule” and set up the schedule as needed.

How to backup SQL Server to OneDrive (schedule)

To save all new settings and run backup job click “Create”

How to backup SQL Server to OneDrive

Also, you can press “More settings…” at your “Settings of Backup” page to find more different backup settings such as E-mail notifications in case of failure or success, Encryption and Compression, also add Custom scripts or add some local folders to backup.

As you can see it takes about 5 minutes to create SqlBak backup job which will make backups according to your schedule and send them to OneDrive.

[Total: 1    Average: 5/5]

2 thoughts on “How to Backup SQL Server to OneDrive

Leave a Reply

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