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 by SQL Backup Master at 8:22 pm