OneDrive for Business

Adding OneDrive for Business storage as a backup destination

To send backups to OneDrive for Business storage, you first need to set up a destination in the “Storages” page:

1. Go to the “Storages” page and click “Add Storage” and select OneDrive for Business as the storage destination:

Add OneDrive for Business storage destination SqlBak

2. In the “New OneDrive for Business Settings” pop-up window, click Authorize with Windows Live button:

Authorize OneDrive storage destination SqlBak

3. Grant SqlBak access to OneDrive for Business storage:

Grant SqlBak access to OneDrive storage

4. Once configured, click “Test” to verify the connection. If successful, click “Save & Close” to apply your settings.

OneDrive for Business storage basic settings SqlBak

These are the basic settings required to configure Google Drive storage as a backup destination.

Advanced OneDrive for Business Settings (Optional)

You can further customize your backup storage with the following options:

  • Download Parallel Threads – Increase the number of threads to boost download performance, especially for large files.

  • Validate file checksum after transfer – Verifies data integrity by checking the file checksum after transfer completion.

OneDrive for Business storage advanced settings SqlBak

Steps to add OneDrive for Business storage to a backup job:

  1. Return to the Dashboard page.

  2. Open the backup job you want to modify (or create a new one), and click the “Edit” button.

  3. Navigate to the Storage Destination section.

  4. Click “Add Backup Storage”.

 

Add storage destination SqlBak

5. Select OneDrive for Business storage as the destination.

Select OneDrive for Business destination SqlBak

6. In the configuration window, specify the following:

    • Autodelete old backups after – Define a retention period for automatically deleting old backups.

    • Enable minimum backups – Set the minimum number of backups to retain, even if they exceed the defined retention period.

OneDrive for Business retention options

Optional settings:

  • Store the following backup types (Full, Diff, T-Log) – Choose which backup types to store in this destination.

  • Auto delete Differential Backups after – Define a retention period specifically for differential backups.

  • Auto delete T-Log Backups after – Define a retention period specifically for transaction log backups.

  • Enable minimum Differential or T-Log backups – Set the minimum number of differential or T-Log backups to keep, even if older than the retention limit.

  • Emergency storage – Use this option to designate Azure Blob as an emergency/failover destination in case the primary backup storage becomes unavailable.

OneDrive for Business retention settings SqlBak