SQL Backup Master Blog

Looking for an easy way to back up SQL data to Backblaze? With SQL Backup Master and Backblaze B2 cloud storage, you can automate and secure your SQL Server backups in just a few steps. Follow the guide below to set up and run your backup job.

STEP 1 – Backblaze Account Setup

Go to the Backblaze B2 homepage and click the Sign Up button to create an account. You’ll only need to provide an email address and password to proceed. Once logged in, you’ll be ready to create storage buckets for your SQL backups.

STEP 2 – CONNECTING TO A SQL SERVER DATABASE

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

In the Server name field, type or select the name of the SQL Server instance you’re backing up. Examples include:

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

Use the drop-down arrow in the Server name field to automatically find local or remote SQL Server instances. Click Test SQL Connection to verify connectivity, then select OK.

STEP 3 – Select Databases to Back Up

After connecting, the Database Backup Editor window will list available databases under Source. Check the boxes for the databases you want to include in this backup job.

Enable Back up all non-system databases if you’d like new databases to be automatically added to future backups on this SQL Server.

STEP 4 – Add a Backblaze B2 Backup Destination

Click the Add icon under Destinations. A window listing possible backup destinations will appear:

Double-click Backblaze B2. The Backblaze B2 Destination Settings window will appear, prompting you to authorize SQL Backup Master’s connection to your Backblaze account. Enter your Access Key, Secret Key, and choose your Bucket. Use the Test button to confirm a successful connection.

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

STEP 5 – RUN THE BACKUP

In the main SQL Backup Master window, locate your newly created backup job and click Back up now to begin sending your SQL backups to Backblaze B2.

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 Backblaze. 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.

Need a streamlined way to back up SQL to Amazon S3? With SQL Backup Master, you can quickly automate backups and securely store your databases in Amazon’s cloud. Follow the steps below to configure your Amazon S3 account, connect to SQL Server, and create a reliable offsite backup solution.

STEP 1 – AMAZON S3 ACCOUNT CREATION AND SETUP

To create an Amazon S3 account, navigate to Amazon’s AWS home page and select Get Started with Amazon S3. Click the Create a new AWS account button below the login field, then follow the on-screen instructions to set up and verify your new AWS account.

STEP 2 – CONNECTING TO YOUR SQL SERVER

In SQL Backup Master, open the Backup and Restore tab and select New Backup. Within the Database Backup Editor window that appears, choose Choose SQL Server to bring up the Connect to SQL Server dialog:

Enter the name of the SQL Server instance you’re connecting to in the Server name field. 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 named instance on a remote computer named “Server1.”
• Server1 – Specifies an unnamed SQL Server instance on a remote computer named “Server1.”

You can also use the drop-down arrow in the Server name field to detect local and remote SQL Server instances. Click Test SQL Connection to verify connectivity, then select OK.

STEP 3 – SELECT DESIRED DATABASES TO BACK UP

Now that you’re connected, the Database Backup Editor window will display all available databases under Source. Check the boxes for the databases you wish to include in this backup job.

Alternatively, enable Back up all non-system databases to automatically include any new databases created on your SQL Server over time.

STEP 4 – CHOOSE S3 AS YOUR BACKUP DESTINATION

Under the Destinations header in the Database Backup Editor, click the Add button to specify where your backups will be stored. A new window will appear, listing compatible backup destinations:

Double-click Amazon S3. The Amazon S3 Destination Settings window will then open. This is where you’ll configure your S3 credentials.

Retrieve your Access key and Secret key from the Security Credentials section of your AWS Management Console, and paste them into the corresponding fields in SQL Backup Master. Enter the name of your existing S3 Bucket in the third field. Once you’ve filled in the details, click Test to confirm a successful connection, and then select OK.

Back at the Database Backup Editor window, click the Save icon in the bottom-right corner to finalize your backup destination settings.

STEP 5 – RUN THE BACKUP

Return to the main SQL Backup Master window, select your newly created backup job, and click Back up now to begin sending your SQL Server databases to Amazon S3.

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 Amazon S3. 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 Google Drive—be sure to explore the full feature set of SQL Backup Master by Key Metric Software.

Looking for a straightforward way to backup SQL data to Google Drive? Utilizing Google Drive as a backup destination ensures your databases are stored safely offsite. Follow this quick guide to configure SQL Backup Master to automatically back up SQL databases to Google Drive.

STEP 1 – CREATE AND SET UP YOUR GOOGLE DRIVE ACCOUNT

Open the Google Drive homepage and sign up or log in using the account best suited for your organization’s needs. Follow any prompts and provide the requested information. Ensure you have adequate storage space to hold your SQL database backups.

STEP 2 – CONNECT TO SQL SERVER

Open SQL Backup Master and click on Backups in the navigation center, then select New Backup. The Database Backup Editor window will appear. Within this window, select the Choose SQL Server tab. The Connect to SQL Server window will then open.

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

• (local)\SQLExpress – Default SQL Express named instance on the local machine.
• (local) – Local SQL Server installation without a named instance.
• Server1\SQLExpress – 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 the Server Name field to discover local and remote SQL Server instances automatically.

Click Test SQL Connection to confirm your connection, then click OK. Next, click the Save button (bottom-left).

When the Windows user account configuration notice appears, click Yes to continue. Then, check Run Backup with a Specific Windows Account and enter your authentication credentials (typically only needed once per backup job).

STEP 3 – SELECT DESIRED DATABASES TO BACK UP

After connecting to a SQL Server instance, the Database Backup Editor window will list available databases under Source. Select all the databases you want to include in this backup job.

TIP: Enable Back up all Non-System Databases to automatically include newly created databases on the target server going forward.

STEP 4 – ADD A GOOGLE DRIVE BACKUP DESTINATION

Under the Destinations header in the Database Backup Editor, click the Add button. A window will appear, listing all possible backup destinations supported by SQL Backup Master.

Double-click Google Drive (or select it and click Select) to choose it as your backup destination.

You will then see the Google Drive Destination Settings window, where you can authorize a connection to your Google Drive account.

Select Authorize Now and sign in with your Google Drive credentials. Follow the prompts to grant SQL Backup Master permission to upload backup files to your Google Drive. You should see confirmation screens during the authorization process:

Click Continue when prompted. Once authorization is successful, you should see a confirmation screen similar to this:

STEP 5 – RUN THE BACKUP JOB

Return to the main window in SQL Backup Master, select your newly created backup job, and hit Back up now to begin backing up your databases to Dropbox. If the backup job does not complete successfully, consult the log file for more details on any errors.

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 Google Drive. 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.

STEP 1 – GOOGLE DRIVE ACCOUNT CREATION AND SETUP

To create a Google Drive account, navigate to the Google Drive home page and select the Sign up at no cost option near just under the Go to Drive button. 

Next, enter your contact information and required credentials to create your account. Once your account is created, you will be taken to the Google Drive main page.

STEP 2 – CONNECT YOUR SQL SERVER

In SQL Backup Master, navigate to the Backup and Restore tab, here select the New Backup button. Then the Database Backup Editor window will open, select the tab labeled Choose SQL Server. This will bring up the Connect to SQL Server window:

In the Server name field, enter or select the name of the SQL Server instance that you are going to connect 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”.

Use the Test SQL Connection button to test your connection, then hit Ok.

STEP 3 – SELECT DATABASES TO BACK UP

Once you’ve properly connected to a SQL Server instance, the Database Backup Editor window will display all available databases under the Source label. Select the database(s) you want to include in this backup job

Checking the box labeled Back up all non-system databases will back up all new databases created on the target SQL Server in the future automatically.

STEP 4 – ADD A BACKUP DESTINATION

Click the button labeled Add under the window header labeled Destinations. This will bring up a window displaying all compatible backup destinations for your SQL Database:

Choose Google Drive by double-clicking the Google Drive selection box.

After choosing Google Drive as your destination, the Google Drive Destination Settings window will appear. This is where you establish a connection to Google Drive. Click on the Authorize Now button and input your Google login information on the new window. 

Signing in to your Google account through the browser will bring up the following window:

Select the Allow option then close the window to continue.

You can use the Test button in the bottom left corner of the Google Drive Destination Settings window to verify that you have a successful connection to your desired Google account, select Ok, then click the Ok button on the main window to continue. 

Back at the bottom right corner of the Database Backup Editor window, use the Save button to establish your backup destination. 

STEP 5 – RUN THE BACKUP JOB

Back in the main window of the application, select your newly created backup job and use the Back up now button to begin backing up your SQL Server to your Google Drive.

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

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.

Need an efficient way to back up SQL to Google Cloud Storage? With SQL Backup Master, you can quickly configure, automate, and maintain secure offsite backups for your SQL Server databases. Follow the steps below to set up Google Cloud Storage (GCS) as your backup destination.

STEP 1 – GOOGLE CLOUD STORAGE ACCOUNT SETUP

Start by navigating to the Google Cloud Storage homepage and selecting either Get started for free or Try Storage free. You’ll be asked to provide company credentials and a phone number as part of Google’s verification process.

STEP 2 – CONNECT SQL SERVER DATABASE

In the Backup and Restore window of SQL Backup Master, click New Backup. The Database Backup Editor window will appear. Select Choose SQL Server to open the Connect to SQL Server dialog.

In the Server name field, enter or select the name of your SQL Server instance. Common examples include:

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

Click the Test SQL Connection button to confirm connectivity; then select OK.

STEP 3 – SELECT DESIRED DATABASES TO BACK UP

After connecting, the Database Backup Editor window will list your available databases under Source. Check the databases you want to back up as part of this job.

TIP: Enable Back up all non-system databases to automatically include any newly created databases on the target SQL Server in subsequent backups.

STEP 4 – ADDING A BACKUP DESTINATION

Under the Destinations header, click the Add icon. A window will appear, displaying compatible backup destinations supported by SQL Backup Master:

Double-click Google Cloud Storage to select it as your backup destination. The Google Cloud Storage Destination Settings window will appear, prompting you to enter your Access key, Secret key, and Bucket. You can generate these keys from your Google Cloud project credentials.

Click the Test button to verify that SQL Backup Master can connect to your GCS bucket. Select OK, then confirm once more on the main window to continue. Finally, click the Save icon at the bottom-right of the Database Backup Editor to finalize your backup destination.

STEP 5 – RUN THE BACKUP

Return to the main SQL Backup Master window, locate your new backup job, and click Back up now to begin sending your SQL Server databases to Google Cloud Storage. If the backup job fails, consult the log file for more detailed information on any errors.

That’s it! You can now safeguard your SQL Server data offsite by leveraging the reliability of Google Cloud Storage—powered by SQL Backup Master from Key Metric Software.

Key Metric Software is proud to release version of 5.4 of our acclaimed SQL Backup Master software product.

This release includes powerful new capabilities, including SFTP (SSH File Transfer Protocol) private key file authentication, support for PowerShell scripts during custom batch script execution, and more.

We’ve also implemented a number of security improvements and bug fixes in this release, including support for obscuring access keys in backup destination configuration windows and the addition of backup destination module loading verification.

For details, please see the SQL Backup Master 4.5 release notes.

A new version of SQL Backup Master has arrived, and it delivers the often-requested ability to control database file paths during the recovery process. Let’s take a closer look.

I’ll start by launching the Backup Recovery Explorer, selecting a backup destination (an Amazon S3 bucket in this case), and then navigating to a test database that we’ll use for recovery demonstration purposes. I use the Action button to begin restoring a database from backup.

The Restore from Backup window appears, allowing me to configure the target database for the recovery operation. After clicking the Next button, SQL Backup Master will download the database backup and present me with a configurable list of database file paths.

I can now double-click a restore path to edit it directly, or use the associated folder icon to browse for a database file restore path. Finally, I click the Restore Now button to initiate the database backup recovery.

The latest release of SQL Backup Master is here. Version 5.2 provides official support for Windows 11 and Server 2022 along with a number of improvements and bug fixes.

Please see the release notes for details.

Key Metric Software has released SQL Backup Master v5.1.

This version includes a new dark theme, numerous performance improvements, HTML formatting for notification emails, and much more.

For a full review of what’s new, please see the product release notes.

Key Metric Software is proud to announce the general availability of SQL Backup Master 5. This new, major version offers a wide range of improvements and new features.

Learn about what’s new in SQL Backup Master v5.

We’re excited for you to get your hands on the new version. As always, we recommend testing your existing backup jobs after upgrading.

Existing standard or pro edition customers can upgrade to v5 at a 50% pricing discount (vs. new licenses).

Download SQL Backup Master v5 when you’re ready to upgrade.