How to Backup Up SQL Server to Backblaze

STEP 1 – Backblaze Account Setup

Navigate to the Backblaze home page and select the B2 Cloud Storage tab at the top banner of the web page, then click the Sign Up button to begin account creation. Backblaze will only require an email address and password to access the bucket creation page. 

STEP 2 – CONNECTING TO A SQL SERVER DATABASE

Head to the Backup and Restore window of SQL Backup Master and select New Backup. In the Database Backup Editor window that appears, select the Choose SQL Server tab. The Connect to SQL Server window will then be brought up:

In the Server name field, enter the name of the SQL Server instance that you are connecting to. Common examples include:

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

Another way to find local and remote SQL Server instances is by using the drop-down arrow of the Server name field.

Click the Test SQL Connection button to test your connection, then hit OK.

STEP 3 – Select Databases to Back Up

Once you’ve successfully connected to a SQL Server instance, the Database Backup Editor window will show the available databases in the left-most column labeled Source. Select the databases you want to back up as part of this job.

You can also check the Back up all non-system databases Backblaze. Doing this will back up all new databases created on the target SQL Server in the future automatically. 

STEP 4 – Add a Backblaze Backup Destination

Select the Add icon under the window header labeled Destinations. This will bring up a window displaying all of the possible backup destinations for your SQL Database:

Choose Backblaze by double-clicking the Backblaze selection box. 

The Backblaze Destination Settings window will then appear. This is where you authorize a connection to Backblaze. This window asks for your Access key, Secret key, and Bucket. Input the required information, then use the Test button to make sure your information is correct and the connection is successful. 

Back at the Database Backup Editor window, use the Save icon to finalize your backup destination. 

STEP 5 – RUN THE BACKUP

In the main window of the application, select your newly created backup job and click the Back up now button to begin the backup for your OneDrive files.

If the backup job does not successfully complete, review the log file for further details.

posted by SQL Backup Master at 11:40 am