{"id":215,"date":"2022-06-08T11:43:09","date_gmt":"2022-06-08T16:43:09","guid":{"rendered":"https:\/\/www.sqlbackupmaster.com\/wordpress\/?p=215"},"modified":"2025-04-01T05:45:54","modified_gmt":"2025-04-01T10:45:54","slug":"how-to-back-up-sql-databases-to-onedrive","status":"publish","type":"post","link":"https:\/\/www.sqlbackupmaster.com\/wordpress\/2022\/06\/08\/how-to-back-up-sql-databases-to-onedrive\/","title":{"rendered":"Back Up SQL Databases to OneDrive"},"content":{"rendered":"\n

Looking to quickly back up SQL to OneDrive?<\/strong> With SQL Backup Master<\/strong>, you can effortlessly protect your SQL Server databases by storing them in Microsoft\u2019s secure OneDrive cloud. Follow the steps below to set up, authorize, and run your backups in just a few minutes.<\/p>\n\n\n\n

STEP 1 \u2013 ONEDRIVE ACCOUNT CREATION AND SETUP<\/strong><\/h3>\n\n\n\n

To create a OneDrive account, navigate to Microsoft OneDrive\u2019s homepage<\/a>. Select the Sign In<\/strong> button and input your Microsoft account details. After verifying your credentials, you\u2019ll be taken to OneDrive<\/a>.<\/p>\n\n\n\n

STEP 2 \u2013 CONNECT TO YOUR SQL SERVER<\/strong><\/h3>\n\n\n\n

Navigate to the Backup and Restore<\/strong> window in SQL Backup Master<\/strong> and select New Backup<\/strong>. In the Database Backup Editor<\/strong> window that appears, click the Choose SQL Server<\/strong> button. The Connect to SQL Server<\/strong> window will then pop up.<\/p>\n\n\n\n

\"Connecting<\/figure>\n\n\n\n

In the field labeled Server name<\/strong>, enter the name of the SQL Server instance that you want to connect to, or use the drop-down arrow to select one. Common examples include:<\/p>\n\n\n\n

    \n
  • (local)\\SQLExpress<\/em><\/strong> \u2013 Specifies the default SQL Express named instance on the local computer.<\/li>\n\n\n\n
  • (local)<\/em><\/strong> \u2013 Specifies the local SQL Server installation (without an instance name).<\/li>\n\n\n\n
  • Server1\\SQLExpress<\/em><\/strong> \u2013 Specifies the default SQL Express named instance on a remote computer named \u201cServer1.\u201d<\/li>\n\n\n\n
  • Server1<\/em><\/strong> \u2013 Specifies an unnamed SQL Server instance on a remote computer named \u201cServer1.\u201d<\/li>\n<\/ul>\n\n\n\n

    Click Test SQL Connection<\/strong> to verify your connection, then select OK<\/strong>.<\/p>\n\n\n\n

    STEP 3 \u2013 SELECT DATABASES TO BACK UP<\/strong><\/h3>\n\n\n\n

    Once you\u2019ve connected to a SQL Server instance, the Database Backup Editor<\/strong> window will appear, displaying available databases in the Source<\/strong> column. Check the database(s) you want to include in this backup job.<\/p>\n\n\n\n

    Enabling Back up all non-system databases<\/strong> ensures that any newly created databases on the targeted SQL Server are automatically backed up going forward.<\/p>\n\n\n\n

    STEP 4 \u2013 ADD A BACKUP DESTINATION<\/strong><\/h3>\n\n\n\n

    Click the Add<\/strong> button under the Destinations<\/strong> header. This opens a window that lists all possible backup destinations for your SQL databases:<\/p>\n\n\n\n

    \"Selecting<\/figure>\n\n\n\n

    Double-click the option labeled OneDrive<\/strong>.<\/p>\n\n\n\n

    The OneDrive Destination Settings<\/strong> window appears. This is where you authorize SQL Backup Master to connect with your OneDrive. Click Authorize Now<\/strong> and input your Microsoft login details in the new window.<\/p>\n\n\n\n

    After signing in to your Microsoft account and verifying your details, you\u2019ll be prompted to confirm SQL Backup Master\u2019s access to OneDrive. Select Yes<\/strong> to continue.<\/p>\n\n\n\n

    You\u2019ll then be shown a unique authentication code. Copy it (Ctrl + C<\/strong>), exit the browser, and return to SQL Backup Master. Paste the code into the Authorization Code<\/strong> window and click OK<\/strong>.<\/p>\n\n\n\n

    Use the Test<\/strong> button in the OneDrive Destination Settings<\/strong> window to confirm a successful connection, then select OK<\/strong>.<\/p>\n\n\n\n

    Finally, click the Save<\/strong> icon at the bottom-right of the Database Backup Editor<\/strong> window to finalize your backup destination.<\/p>\n\n\n\n

    STEP 5 \u2013 RUN THE BACKUP<\/strong><\/h3>\n\n\n\n

    In the main application window, select your newly created backup job and click Back up now<\/strong> to initiate your \u201cbackup SQL to OneDrive\u201d process.<\/p>\n\n\n\n

    If the backup job doesn\u2019t complete successfully, check the log file for more details on the issue.<\/p>\n\n\n\n

    That\u2019s it! By backing up SQL databases to OneDrive, you\u2019ll streamline data protection and offsite storage\u2014ensuring quick recovery and peace of mind for your organization. For additional features\u2014like backing up to Dropbox, Google Drive, or Amazon S3\u2014explore the full suite of capabilities of SQL Backup Master from Key Metric Software.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

    Looking to quickly back up SQL to OneDrive? With SQL Backup Master, you can effortlessly protect your SQL Server databases by storing them in Microsoft\u2019s secure OneDrive cloud. Follow the steps below to set up, authorize, and run your backups in just a few minutes. STEP 1 \u2013 ONEDRIVE ACCOUNT CREATION AND SETUP To create […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/215"}],"collection":[{"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/comments?post=215"}],"version-history":[{"count":12,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/215\/revisions"}],"predecessor-version":[{"id":518,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/215\/revisions\/518"}],"wp:attachment":[{"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/media?parent=215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/categories?post=215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/tags?post=215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}