SQL Backup Master Blog

Looking to back up SQL Server databases to OneDrive for Business? With SQL Backup Master, you can easily set up offsite storage and ensure a quick recovery strategy for your critical data. Follow the steps below to configure and run your backup job.

STEP 1 – ONEDRIVE FOR BUSINESS ACCOUNT CREATION

To create a OneDrive for Business account, navigate to the OneDrive for Business homepage. Then click the Download OneDrive for Business button and sign in with your Microsoft credentials. Once logged in, follow any prompts to finalize your setup.

STEP 2 – CONNECT TO YOUR SQL SERVER

Within SQL Backup Master, open the Backup and Restore window and click New Backup. In the Database Backup Editor window that appears, click the Choose SQL Server button. This will bring up the Connect to SQL Server window.

In the Server name field, type or select the name of your SQL Server instance. Common examples include:

• (local)\SQLExpress – The default SQL Express named instance on the local computer.
• (local) – A local SQL Server installation without an instance name.
• Server1\SQLExpress – A default SQL Express named instance on a remote computer named “Server1.”
• Server1 – An unnamed SQL Server instance on a remote computer named “Server1.”

Click Test SQL Connection to verify connectivity, then select OK.

STEP 3 – SELECT DATABASES TO BACK UP

After connecting, the Database Backup Editor window will display available databases in the Source column. Choose the databases you want to back up as part of this job.

TIP: Enable Back up all non-system databases if you want newly created databases on the target SQL Server to be automatically included in future backups.

STEP 4 – ADD A BACKUP DESTINATION

Click Add under the Destinations header in the Database Backup Editor window. This will bring up a list of supported backup destinations:

Double-click OneDrive for Business to select it. The OneDrive for Business Destination Settings window will appear, allowing you to authorize SQL Backup Master to connect to your OneDrive for Business account.

Click Authorize Now and sign into your Microsoft account in the new browser window. After confirming, you’ll see a prompt asking you to Allow SQL Backup Master access.

Upon clicking Allow, you’ll be presented with a unique authorization code. Copy (Ctrl + C) this code, exit the browser, then paste (Ctrl + V) it into the Authorization Code window in SQL Backup Master. Click OK to finalize.

Use the Test button to ensure SQL Backup Master can successfully connect to OneDrive for Business. Click OK to save your settings, then Save again in the Database Backup Editor to confirm your new backup destination.

STEP 5 – RUN THE BACKUP

In the main SQL Backup Master window, select your newly created backup job and click Back up now to begin sending your SQL databases to OneDrive for Business. If the backup fails to complete, check the log file for more information.

That’s it! You can now store your SQL Server backups offsite with OneDrive for Business, ensuring increased security and a streamlined disaster recovery process.