How to Back Up SQL Databases to OneDrive

STEP 1 – ONEDRIVE ACCOUNT CREATION AND SETUP

To create a OneDrive account, navigate to Microsoft OneDrive’s homepage , here you will select the Sign In button and input your Microsoft account information. After logging in to and verifying your Microsoft account, you will be taken to OneDrive.

STEP 2 – CONNECT TO YOUR SQL SERVER

Navigate to the Backup and Restore window of SQL Backup Master and select the New Backup button. In the Database Backup Editor window that shows up, click the Choose SQL Server button. The Connect to SQL Server window will then be brought up.

In the field with the label Server name, enter the name of the SQL Server instance that you are connecting to, or use the drop-down tab of the field to select one. Common examples include:

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

Hit the Test SQL Connection button to test your connection to the SQL Server, then select OK.

STEP 3 – SELECT DATABASES TO BACK UP

After you’ve connected to a SQL Server instance, the Database Backup Editor window will appear, showing available databases in the Source column. Select the database(s) you want to back up as part of this backup job.

Enabling the Back up all non-system databases option will back up all new databases created on the targeted SQL Server automatically in the future. 

STEP 4 – ADD A BACKUP DESTINATION

Click on the Add button under the Destinations window header. This will pull up a window displaying all of the possible backup destinations for your SQL Database:

Double-click the selection box labeled OneDrive

The OneDrive Destination Settings window will appear. This is where you establish and authorize a connection with your OneDrive. Select the Authorize Now tab and input your Microsoft login information on the new window. 

Signing in to your Microsoft account and verifying your information through the browser window will bring up the following window:

Select Allow to continue.

Next, you will be presented with a unique authentication code that will be required to continue verification. Copy this code with Ctrl + C, then exit out of the browser window. 

Paste your authentication code into the text field of the Authorization Code window:

Select Ok.

Use the Test button on the OneDrive Destination Settings window to make sure you have successfully connected to your OneDrive account, then select Ok

Select the Ok button on the main window to continue. 

At the bottom right corner of the Database Backup Editor window, click on the Save icon to finalize your backup destination. 

STEP 5 – RUN THE BACKUP

In the main window of the application, select your newly created backup job and click the Back up now button to begin the backup for your OneDrive files.

If the backup job does not successfully complete, review the log file for further details.

posted by SQL Backup Master at 11:43 am