SQL Backup Master Blog

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’s cloud environment. Follow the steps below to configure your Box account, connect to SQL Server, and safeguard your critical data offsite.

STEP 1 – BOX ACCOUNT CREATION AND SETUP

On the home page of Box, select the Get Started 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.

STEP 2 – CONNECT TO SQL SERVER

In SQL Backup Master, open the Backup and Restore window and select New Backup. In the Database Backup Editor window that appears, click the Choose SQL Server tab. This will bring up the Connect to SQL Server window.

In the Server name field, enter the name of the SQL Server instance that you want to back up. Common examples include:

• (local)\SQLExpress – Default SQL Express named instance on the local computer.
• (local) – A local SQL Server installation without an instance name.
• Server1\SQLExpress – A default SQL Express named instance on a remote computer named “Server1.”
• Server1 – An unnamed SQL Server instance on a remote computer named “Server1.”

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

STEP 3 – SELECT DESIRED DATABASES TO BACK UP

After a successful connection, the Database Backup Editor window will list available databases under Source. Choose which databases you want to include in the backup job.

TIP: Enable Back up all non-system databases to automatically capture any new databases created on the target SQL Server going forward.

STEP 4 – ADD A BOX BACKUP DESTINATION

Under the Destinations header in the Database Backup Editor, click the Add icon. This will bring up a window listing all possible SQL backup destinations:

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

You’ll receive a unique authentication code. Copy it (Ctrl+C), exit the browser window, and paste (Ctrl+V) this code into the Authorization Code field in SQL Backup Master. Select OK.

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

Finally, click the Save icon at the bottom-right of the Database Backup Editor window to establish Box as your backup destination.

STEP 5 – RUN THE BACKUP JOB

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

If the backup job doesn’t complete successfully, review the application log file for error details or additional troubleshooting information.

That’s it! You are now backing up your SQL database to Box. By automating backups with SQL Backup Master, you’ll have peace of mind knowing your critical data is protected offsite and readily available for recovery.

If you’re looking for additional backup destinations—such as Dropbox, OneDrive, or Amazon S3—be sure to explore the full feature set of SQL Backup Master by Key Metric Software.