How to Backup SQL Server to OneDrive for Business

How to Backup SQL Server to OneDrive for BusinessThere are many ways of making SQL Server database backup and there are as many methods as to how and where to store them. But is your method really convenient for you? Lets assume that your backup plan is a full backup once a day, differential backup every six hours and transaction log backup every hour, and all these backups you need to send to OneDrive for Business. If you perform all the scenarios manually, it would take almost all of your time every day. Fortunately, you can do it in minutes with the help of SqlBak.

How to backup SQL Server to OneDrive for Business

Go to your Dashboard page and press “Add new job”, then select “Add backup job” How to Backup SQL Server to OneDrive for Business (job)

Choose the computer where SQL Server is located and then check for SQL Server connections. Then click “Continue to job settings”How to Backup SQL Server to OneDrive for Business (connection)

Select the databases which you are going to backup. How to Backup SQL Server to OneDrive for Business (databases)Now you need to add backup destinations, to do that press “Add backup destination” in the “Store backups in selected destinations” section. How to Backup SQL Server to OneDrive for Business (add backup destination) In the “Add destination” window press “OneDrive for Business”How to Backup SQL Server to OneDrive for Business (choose destination)Then enter endpoint URL and click “Authorize” to open the browser and allow SqlBak to access OneDrive for Business. Also, you can choose types of backups this job should send to the specified destination by clicking “Advanced OneDrive Settings”. Press “Test” to check connections with OneDrive for Business and then press “Save & Close” to apply all your settings. How to Backup SQL Server to OneDrive for Business (backup settings)Then setup your backup settings, press “Show advanced backup schedule” to set up the schedule in the best possible way. How to Backup SQL Server to OneDrive for Business (schedule)

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

Also, you can set up more different settings like E-mail notifications in case of failure or success, Compression and Encryption, specify Custom scripts or add some local folders to backup. And this is not the exhaustive list of benefits SqlBak offers.

It is better to once spend 5 or 10 minutes setting up SqlBak backup job and then have some free time while SqlBak makes backups according to your schedule and sends them to OneDrive for Business.

Leave a Reply

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