SQL Backup Master 6 is Available

Key Metric Software has released SQL Backup Master 6 – a new major version of our SQL Server database backup tool.

New features include backup reporting (with optional scheduling and email delivery), webhook notifications, support for SQL Server 2022, and much more.

For a visual overview of what’s new, please see:

https://www.sqlbackupmaster.com/features/whatsnew

Download the new SQL Backup Master v6 release here:

https://www.sqlbackupmaster.com/download

Posted: July 11, 2022 2:00 pm

How to Back Up SQL Databases to OneDrive

STEP 1 – ONEDRIVE ACCOUNT CREATION AND SETUP

To create a OneDrive account, navigate to Microsoft OneDrive’s homepage , here you will select the Sign In button and input your Microsoft account information. After logging in to and verifying your Microsoft account, you will be taken to OneDrive.

STEP 2 – CONNECT TO YOUR SQL SERVER

Navigate to the Backup and Restore window of SQL Backup Master and select the New Backup button. In the Database Backup Editor window that shows up, click the Choose SQL Server button. The Connect to SQL Server window will then be brought up.

In the field with the label Server name, enter the name of the SQL Server instance that you are connecting to, or use the drop-down tab of the field to select one. 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”.

Hit the Test SQL Connection button to test your connection to the SQL Server, then select OK.

STEP 3 – SELECT DATABASES TO BACK UP

After you’ve connected to a SQL Server instance, the Database Backup Editor window will appear, showing available databases in the Source column. Select the database(s) you want to back up as part of this backup job.

Enabling the Back up all non-system databases option will back up all new databases created on the targeted SQL Server automatically in the future. 

STEP 4 – ADD A BACKUP DESTINATION

Click on the Add button under the Destinations window header. This will pull up a window displaying all of the possible backup destinations for your SQL Database:

Double-click the selection box labeled OneDrive

The OneDrive Destination Settings window will appear. This is where you establish and authorize a connection with your OneDrive. Select the Authorize Now tab and input your Microsoft login information on the new window. 

Signing in to your Microsoft account and verifying your information through the browser window will bring up the following window:

Select Allow to continue.

Next, you will be presented with a unique authentication code that will be required to continue verification. Copy this code with Ctrl + C, then exit out of the browser window. 

Paste your authentication code into the text field of the Authorization Code window:

Select Ok.

Use the Test button on the OneDrive Destination Settings window to make sure you have successfully connected to your OneDrive account, then select Ok

Select the Ok button on the main window to continue. 

At the bottom right corner of the Database Backup Editor window, click on 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: June 8, 2022 11:43 am

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: June 8, 2022 11:40 am

How To Back up SQL Databases to Amazon S3

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, and click on the Create a new AWS account button below the login field. Follow the instructions given by the AWS Console to get your account set up. 

STEP 2 – CONNECTING TO YOUR SQL SERVER

In SQL Backup Master’s main window, navigate to the Backup and Restore tab and select the New Backup button. In the Database Backup Editor window that is brought up, select the Choose SQL Server option. You will then see  the Connect to SQL Server window: 

From here, enter the name of the SQL Server instance that you are connecting to in the Server name field. Common examples of this 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 option of finding local or remote SQL Server instances is to use the drop-down arrow of the Server name field.

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

STEP 3 – SELECT DESIRED DATABASES TO BACK UP

Now that you’re connected to a SQL Server instance, the Database Backup Editor window will show up with the available databases in the Source column. Select the databases you want to back up as part of this job out of this list.

You can also use the Back up all non-system databases check box. Enabling this feature will back up all new databases created on the target SQL Server automatically. 

STEP 4 – CHOOSE S3 AS YOUR BACKUP DESTINATION

Under the Destinations header of the Database Backup Editor window, click the Add button to add a destination. This will make a new window appear, displaying all compatible backup destinations: 

 Select Amazon S3 by double-clicking the section box labeled Amazon S3.

The Amazon S3 Destination Settings window will then appear. This is where you will configure the credentials for your S3 account:

Pull up the Security Credentials page of your Amazon S3 account to find your Access key and Secret key. Copy (ctrl+c) and paste (ctrl+v) both your Access key and Secret key in the first and second text fields respectively, then input your preferred Bucket in the third. Your Bucket must already exist in your S3 storage account to be successfully backed up.

After you have input your keys and bucket, and tailored your Amazon S3 Destination Settings to your preferred configuration, use the Test button to make sure everything is set up properly. Hit Ok after the test has completed successfully. Then select Ok on the Amazon S3 Destination Settings window to continue. 

Back at the bottom right corner of the Database Backup Editor window, click the Save icon to finalize and establish your backup destination. 

STEP 5 – RUN THE BACKUP

Back in the main window of the application, select your newly created backup and hit the Back up now button to begin backing up your SQL Server to Amazon S3.

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

Posted: June 8, 2022 11:30 am

How To Back up SQL Databases to Google Drive

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.

Posted: June 8, 2022 11:18 am

How to Back Up SQL Databases to Box

STEP 1 – BOX ACCOUNT CREATION AND SETUP

On the home page of Box, select the Get Started tab from the website’s top banner and select the Box package that best fits your needs, then input the required personal information/business credentials. 

STEP 2 – CONNECT TO SQL SERVER

In the Backup and Restore window of SQL Backup Master, 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 field labeled Server name, 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 DESIRED 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 click the Back up all non-system databases check box. Enabling this option will back up all new databases created on the target SQL Server in the future automatically. 

STEP 4 – ADD A Box 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 Box by double-clicking the Box selection box. 

The Box Destination Settings window will then appear. This is where you authorize a connection to Box. Select the Authorize Now tab and input your Box login information in the new window. 

Next, you will be presented with a unique authentication code that you will need to continue verification. Copy this code with Ctrl+C and exit out of the browser window. 

Paste your authentication code into the text field of the newly created window:

Select Ok.

Use the Test button in the bottom left corner of the Box Destination Settings window to make sure you have a successful connection to your Box account, and select Ok, then hit the Ok button on the main window to continue. 

Back at the bottom right corner of the Database Backup Editor window, click on the Save icon 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 hit the Back up now button to begin backing up your Box files.

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

Posted: June 8, 2022 11:03 am

How To Back up SQL Databases to Google Cloud Storage

STEP 1 – GOOGLE CLOUD STORAGE ACCOUNT SETUP

To begin the creation of your Google Cloud Storage account, navigate to the Google Cloud Storage home page and select either Get started for free or Try Storage free. Google will then ask for company credentials, and a phone number to aid in the verification process. 

STEP 2 – CONNECT SQL SERVER DATABASE

Select the New Backup button in the Backup and Restore window of SQL Backup Master. In the Database Backup Editor window that appears, select Choose SQL Server. 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, or use the drop-down tab of the field to select one. 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”.

Click on the button labeled Test SQL Connection to test your connection to the SQL Server, then select OK.

STEP 3 – SELECT DESIRED DATABASES TO BACK UP

Now that you’re connected to a SQL Server instance, the Database Backup Editor window will appear, displaying the available databases in the Source column. Select the database(s) you want to back up as part of this backup job.

The Back up all non-system databases check box is an option that allows the program to automatically back up all new databases created on the target SQL Server in the future.

STEP 4 – ADDING A BACKUP DESTINATION

Under the Destinations window header, select the Add icon. The window that is pulled up displays all compatible backup destinations for your SQL Database:

Choose Google Cloud Storage by double-clicking the selection box labeled Google Cloud Storage

The Google Cloud Storage Destination Settings window will then appear. This is where you establish and authorize a connection with your Google Cloud Storage. Input your Access key, Secret key, and Bucket into their respective text fields. Your Access key and Secret key can be generated at your project’s storage page of Google Cloud Storage.

Hit the Test button on the Google Cloud Storage Destination Settings window to make sure you have successfully connected to your Google account, then select Ok

Select the Ok button on the main window to continue. 

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

STEP 5 – RUN THE BACKUP

Back at 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 SQL Server Database to Google Cloud Storage.

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

Posted: June 7, 2022 8:22 pm

How To Back up SQL Databases to Dropbox

STEP 1 – DROPBOX ACCOUNT CREATION AND SETUP

On the home page of Dropbox.com, select the Sign Up tab from the website’s top banner and input your personal credentials, select Create an account, then select the Dropbox package that best fits your needs. At this point in your account setup process, Dropbox will ask you a few questions to best tailor your experience, then bring you to the download page. Select Download Dropbox to begin the application’s installation process. 

STEP 2 – CONNECT TO SQL SERVER

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

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 – 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. Finally, click the Test SQL Connection button to test your connection, then hit OK.

STEP 3 – SELECT DESIRED DATABASES TO BACK UP

After connecting to a SQL Server instance, the Database Backup Editor window will show 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 click the Back up all non-system databases check box. Enabling this option will back up all new databases created on the target SQL Server in the future automatically. 

STEP 4 – ADD A DROPBOX BACKUP DESTINATION

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

Choose Dropbox by double-clicking the Dropbox selection box. 

The Dropbox Destination Settings window will then appear. This is where you authorize a connection to Dropbox. Select the Authorize Now tab and input your Dropbox login information on the new window. 

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

Next, you will be presented with a unique authentication code that you will need to continue verification. Copy this code with Ctrl+C and exit out of the browser window. 

Paste your authentication code into the text field of the newly created window:

Select Ok.

Use the Test button in the bottom left corner of the Dropbox Destination Settings window to make sure you have a successful connection to your Dropbox account, and select Ok, then hit the Ok button on the main window to continue. 

Back at the bottom right corner of the Database Backup Editor window, click on the Save icon 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 hit the Back up now button to begin backing up to your Dropbox.

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

Posted: June 7, 2022 8:14 pm

SQL Backup Master 5.4

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.

Posted: March 17, 2022 7:38 pm

SQL Backup Master 5.3

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.

Posted: December 2, 2021 4:09 pm