{"id":224,"date":"2025-04-06T07:14:08","date_gmt":"2025-04-06T12:14:08","guid":{"rendered":"https:\/\/www.sqlbackupmaster.com\/wordpress\/?p=224"},"modified":"2025-04-06T07:14:08","modified_gmt":"2025-04-06T12:14:08","slug":"onedrive-for-business","status":"publish","type":"post","link":"https:\/\/www.sqlbackupmaster.com\/wordpress\/2025\/04\/06\/onedrive-for-business\/","title":{"rendered":"OneDrive for Business"},"content":{"rendered":"\n

Looking to back up SQL Server databases to OneDrive for Business?<\/strong> With SQL Backup Master<\/strong>, you can easily set up offsite storage and ensure a quick recovery strategy for your critical data. Follow the steps below to configure and run your backup job.<\/p>\n\n\n\n

STEP 1 \u2013 ONEDRIVE FOR BUSINESS ACCOUNT CREATION<\/strong><\/h2>\n\n\n\n

To create a OneDrive for Business account, navigate to the OneDrive for Business homepage<\/a>. Then click the Download OneDrive for Business<\/a> button and sign in with your Microsoft credentials. Once logged in, follow any prompts to finalize your setup.<\/p>\n\n\n\n

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

Within SQL Backup Master<\/strong>, open the Backup and Restore<\/strong> window and click New Backup<\/strong>. In the Database Backup Editor<\/strong> window that appears, click the Choose SQL Server<\/strong> button. This will bring up the Connect to SQL Server<\/strong> window.<\/p>\n\n\n\n

\"SQL<\/figure>\n\n\n\n

In the Server name<\/strong> field, type or select the name of your SQL Server instance. Common examples include:<\/p>\n\n\n\n

    \n
  • (local)\\SQLExpress<\/em><\/strong> \u2013 The default SQL Express named instance on the local computer.<\/li>\n\n\n\n
  • (local)<\/em><\/strong> \u2013 A local SQL Server installation without an instance name.<\/li>\n\n\n\n
  • Server1\\SQLExpress<\/em><\/strong> \u2013 A default SQL Express named instance on a remote computer named \u201cServer1.\u201d<\/li>\n\n\n\n
  • Server1<\/em><\/strong> \u2013 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 connectivity, then select OK<\/strong>.<\/p>\n\n\n\n

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

    After connecting, the Database Backup Editor<\/strong> window will display available databases in the Source<\/strong> column. Choose the databases you want to back up as part of this job.<\/p>\n\n\n\n

    TIP:<\/strong> Enable Back up all non-system databases<\/strong> if you want newly created databases on the target SQL Server to be automatically included in future backups.<\/p>\n\n\n\n

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

    Click Add<\/strong> under the Destinations<\/strong> header in the Database Backup Editor<\/strong> window. This will bring up a list of supported backup destinations:<\/p>\n\n\n\n

    \"SQL<\/figure>\n\n\n\n

    Double-click OneDrive for Business<\/strong> to select it. The OneDrive for Business Destination Settings<\/strong> window will appear, allowing you to authorize SQL Backup Master to connect to your OneDrive for Business account.<\/p>\n\n\n\n

    Click Authorize Now<\/strong> and sign into your Microsoft account in the new browser window. After confirming, you\u2019ll see a prompt asking you to Allow<\/strong> SQL Backup Master access.<\/p>\n\n\n\n

    \"Microsoft<\/figure>\n\n\n\n

    Upon clicking Allow<\/strong>, you\u2019ll be presented with a unique authorization code. Copy (Ctrl + C<\/strong>) this code, exit the browser, then paste (Ctrl + V<\/strong>) it into the Authorization Code<\/strong> window in SQL Backup Master. Click OK<\/strong> to finalize.<\/p>\n\n\n\n

    \"Pasting<\/figure>\n\n\n\n

    Use the Test<\/strong> button to ensure SQL Backup Master can successfully connect to OneDrive for Business. Click OK<\/strong> to save your settings, then Save<\/strong> again in the Database Backup Editor<\/strong> to confirm your new backup destination.<\/p>\n\n\n\n

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

    In the main SQL Backup Master<\/strong> window, select your newly created backup job and click Back up now<\/strong> to begin sending your SQL databases to OneDrive for Business<\/strong>. If the backup fails to complete, check the log file for more information.<\/p>\n\n\n\n

    That\u2019s it! You can now store your SQL Server backups offsite with OneDrive for Business, ensuring increased security and a streamlined disaster recovery process.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

    Looking to back up SQL Server databases to OneDrive for Business? With SQL Backup Master, you can easily set up offsite storage and ensure a quick recovery strategy for your critical data. Follow the steps below to configure and run your backup job. STEP 1 \u2013 ONEDRIVE FOR BUSINESS ACCOUNT CREATION To create a OneDrive […]<\/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\/224"}],"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=224"}],"version-history":[{"count":2,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/224\/revisions"}],"predecessor-version":[{"id":541,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/224\/revisions\/541"}],"wp:attachment":[{"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/media?parent=224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/categories?post=224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/tags?post=224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}