{"id":226,"date":"2022-06-08T11:03:00","date_gmt":"2022-06-08T16:03:00","guid":{"rendered":"https:\/\/www.sqlbackupmaster.com\/wordpress\/?p=226"},"modified":"2025-04-01T08:01:08","modified_gmt":"2025-04-01T13:01:08","slug":"how-to-back-up-sql-databases-to-box","status":"publish","type":"post","link":"https:\/\/www.sqlbackupmaster.com\/wordpress\/2022\/06\/08\/how-to-back-up-sql-databases-to-box\/","title":{"rendered":"Back Up SQL Databases to Box"},"content":{"rendered":"\n

Looking for an easy way to back up SQL to Box?<\/strong> By using SQL Backup Master<\/strong>, you can automate backups of your SQL Server databases and securely store them in Box\u2019s cloud environment. Follow the steps below to configure your Box account, connect to SQL Server, and safeguard your critical data offsite.<\/p>\n\n\n\n

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

On the home page of Box<\/a>, select the Get Started<\/strong> tab from the top banner and choose the plan that best meets your needs. Provide the requested personal or business information to finalize your account.<\/p>\n\n\n\n

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

In SQL Backup Master<\/strong>, open the Backup and Restore<\/strong> window and select New Backup<\/strong>. In the Database Backup Editor<\/strong> window that appears, click the Choose SQL Server<\/strong> tab. 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, enter the name of the SQL Server instance that you want to back up. Common examples include:<\/p>\n\n\n\n

    \n
  • (local)\\SQLExpress<\/em><\/strong> \u2013 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

    TIP<\/strong>: Use the drop-down arrow next to Server name<\/strong> to discover local or remote SQL Server instances automatically. Once selected, click Test SQL Connection<\/strong> to verify connectivity, then hit OK<\/strong>.<\/p>\n\n\n\n

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

    After a successful connection, the Database Backup Editor<\/strong> window will list available databases under Source<\/strong>. Choose which databases you want to include in the backup job.<\/p>\n\n\n\n

    TIP<\/strong>: Enable Back up all non-system databases<\/strong> to automatically capture any new databases created on the target SQL Server going forward.<\/p>\n\n\n\n

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

    Under the Destinations<\/strong> header in the Database Backup Editor<\/strong>, click the Add<\/strong> icon. This will bring up a window listing all possible SQL backup destinations:<\/p>\n\n\n\n

    \"Choosing<\/figure>\n\n\n\n

    Double-click Box<\/strong> to select it as your destination. The Box Destination Settings<\/strong> window will then appear, prompting you to authorize SQL Backup Master<\/strong> to access your Box account. Click Authorize Now<\/strong> and sign into your Box account in the new browser window.<\/p>\n\n\n\n

    You\u2019ll receive a unique authentication code. Copy it (Ctrl+C<\/strong>), exit the browser window, and paste (Ctrl+V<\/strong>) this code into the Authorization Code<\/strong> field in SQL Backup Master. Select OK<\/strong>.<\/p>\n\n\n\n

    TIP<\/strong>: Use the Test<\/strong> button in the bottom-left corner of Box Destination Settings<\/strong> to confirm a successful connection. Click OK<\/strong> to finalize, and then again on the main window to continue.<\/p>\n\n\n\n

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

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

    In the main window of SQL Backup Master, locate your newly created backup job and click Back up now<\/strong> to start sending your SQL databases to Box. If any errors occur, consult the log file for more details.<\/p>\n\n\n\n

    If the backup job doesn\u2019t complete successfully, review the application log file for error details or additional troubleshooting information.<\/p>\n\n\n\n

    That\u2019s it!<\/strong> You are now backing up your SQL database to Box. By automating backups with SQL Backup Master<\/strong>, you\u2019ll have peace of mind knowing your critical data is protected offsite and readily available for recovery.<\/p>\n\n\n\n

    If you\u2019re looking for additional backup destinations\u2014such as Dropbox, OneDrive, or Amazon S3\u2014be sure to explore the full feature set of SQL Backup Master by Key Metric Software.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

    Looking for an easy way to back up SQL to Box? By using SQL Backup Master, you can automate backups of your SQL Server databases and securely store them in Box\u2019s cloud environment. Follow the steps below to configure your Box account, connect to SQL Server, and safeguard your critical data offsite. STEP 1 \u2013 […]<\/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\/226"}],"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=226"}],"version-history":[{"count":6,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/226\/revisions"}],"predecessor-version":[{"id":531,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/posts\/226\/revisions\/531"}],"wp:attachment":[{"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/media?parent=226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/categories?post=226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlbackupmaster.com\/wordpress\/wp-json\/wp\/v2\/tags?post=226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}