BACK UP SQL SERVER TO ONEDRIVE
Protect your SQL Server databases by storing backups in Microsoft OneDrive with SQL Backup Master. This tutorial walks through the complete configuration – from connecting to SQL Server through running and verifying your first backup to OneDrive.
Prerequisites
You'll need a Microsoft account with OneDrive access before configuring the backup job. If you don't have one yet, visit the Microsoft OneDrive homepage, select the Sign In button, and enter your Microsoft account credentials (or create a new account). You'll also need SQL Backup Master installed on a Windows host that can reach your SQL Server instance.
Note that OneDrive for Business is a separate destination type in SQL Backup Master – if your organization uses OneDrive for Business, see the OneDrive for Business tour instead.
Step 1: Create a backup job and connect to SQL Server
In SQL Backup Master, open the backup management area and select New Backup. In the Database Backup Editor window, click Choose SQL Server to open the connection dialog.
Enter the SQL Server instance name in the Server name field. Common examples include:
- (local)\SQLExpress – Default SQL Express named instance on your local computer
- (local) – Local SQL Server installation without an instance name
- Server1\SQLExpress – Default SQL Express named instance on a remote computer called "Server1"
- Server1 – Unnamed SQL Server instance on a remote computer called "Server1"
Tip: Use the dropdown arrow in the Server name field to discover local and remote SQL Server instances automatically.
Click Test SQL Connection to verify the connection, then select OK.
Step 2: Select the databases to back up
The Database Backup Editor displays available databases in the Source column. Check the database(s) you'd like to include in this backup job.
Tip: Enabling Back up all non-system databases automatically backs up newly created databases going forward.
Step 3: Add a OneDrive backup destination
Under the Destinations header, click Add to view the available backup destinations. Double-click OneDrive to proceed.
In the OneDrive Destination Settings window, click Authorize Now and enter your Microsoft login credentials in the browser window that opens. Confirm the requested access permissions by selecting Yes. Copy the authorization code provided, return to SQL Backup Master, paste it into the Authorization Code window, and click OK.
Use the Test button to confirm the connection, then select OK and save the backup job using the save icon in the Database Backup Editor.
Step 4: Schedule the backup job (optional)
SQL Backup Master can run backup jobs automatically on a recurring schedule, keeping your OneDrive backups current without manual intervention. Configure a schedule from within the backup job editor, choosing a recurrence that matches how frequently your data changes.
Step 5: Run the backup job and verify
Select your newly created backup job in the main application window and click Back up now to initiate the backup to OneDrive. If any issues occur, review the job log for error details.
That's it – your SQL Server databases now back up to OneDrive, protected off-site and available for recovery whenever you need them.