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 by SQL Backup Master at 11:18 am