To use OneDrive for Business as a backup destination, you must have a OneDrive for Business account. If you don't already have a OneDrive for Business account, you can visit their website in order to create one.
To create a OneDrive backup destination within SQL Backup Master, click the Add toolbar button in the Destinations section of the Database Backup Editor window. When prompted to choose a destination, select OneDrive and click the Select button.
SQL Backup Master must be authorized to connect with your OneDrive for Business account. Doing so allows SQL Backup Master to upload database backup files to OneDrive for Business on your behalf.
Click the Authorize Now button to proceed. Your default web browser will be launched and directed to a special page within the OneDrive for Business website where you can either Allow or Deny cooperation between SQL Backup Master and your OneDrive for Business account. Click the Grant Access button if you wish to continue with authorization. You will then be shown an authorization code, which you must copy and paste into SQL Backup Master.
Once the authorization is completed, SQL Backup Master will then show the name of the associated OneDrive for Business account.
Congratulations, SQL Backup Master can now back up your SQL Server databases to your OneDrive for Business.
The following optional settings are also available:
•Remote dir - By default, SQL Backup Master will upload database backup files into the root of your OneDrive. Here, you can specify a directory name (e.g. "SQL Backups" or something similar) to use instead. If the directory doesn't already exist, it will be created. You can also specify multiple sub-directories by separating them with a forward slash (e.g. "Apps/SQL Backups").
•Emergency destination - When this option is enabled, the associated backup destination will be used only if all other backup destinations fail.
Each time SQL Backup Master successfully uploads a database backup to a destination, it executes a clean-up procedure.
This allows you to automatically remove database backup files that are older than a specified number of days.
Important: Cleanup operations for a given destination will only affect the database backup files associated with that destination.