There 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? Let’s 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 a “Backup job” as a “Job Type” and click on the “Create job”.
Choose the server where SQL Server is located and then check for SQL Server connections.
Select the databases that you are going to backup.
Now you need to add backup destinations, to do that press “Add destination…” in the “Store backups in destinations” section.
In the “Add destination” window press “OneDrive for Business”
Then click “Authorize” to open the browser and allow SqlBak to access OneDrive for Business. After you are authorized, you can enter the path to a backup folder. 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 click on the “Save & Close” to apply all your settings.
Now it’s time to set us a backup job schedule, to do it, go to the “Schedule backups” section. Click on the “Advanced settings…” button to find more complicated settings.
Don’t forget to press “Save & Exit” to save and run your backup job.
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.