How to Backup SQL Server to OneDrive

How to Backup SQL Server to OneDriveIf you are looking for the easiest way of how to backup  SQL Server to OneDrive, use SQLBackupAndFTP utility. With the help of SQLBackupAndFTP you can set up scheduled SQL Server backup to OneDrive in just 3 minutes. Here we go:

How to Backup SQL Server to OneDrive

Follow these simple steps to create SQL Server database backup job which will make scheduled backups and keep them in OneDrive.

  1. After you have downloaded and installed SQLBackupAndFTP, launch it and connect to the SQL Server. Now go to the “Select databases” section to choose the databases which you are going to backup. How to Backup SQL Server to OneDrive (select databases)
  2. Choose the backup destination by clicking the plus button at the “Store backups in selected destinations” section and select OneDrive.  How to Backup SQL Server to OneDrive (select destination place)
    Press “Authorize” to open the browser and allow SQLBackupAndFTP to access OneDrive.How to backup SQL Server to Azure Storage (Authorize)Enter your Authorization Code and then press “OK”.How to backup SQL Server to Azure Storage (Enter code).pngSelect a folder on your OneDrive, then press “Test” to check the connection to your account, and press “Save & Close” to apply new settings. How to Backup SQL Server to OneDrive (Test)
  3. Turn on “Schedule backups” and click the gear button to set a backup schedule.How to Backup SQL Server to OneDrive (Schedule)
  4. The backup job is ready, click “Run Now” to start a backup immediately.How to Backup SQL Server to OneDrive (Run now)

That is all. Now all SQL Server database backups will be performed according to the schedule. You can find all backups in the specified folder in OneDrive.

[Total: 10    Average: 4.1/5]

Leave a Reply

Your email address will not be published.