How to Backup SQL Server to Google Drive

How to Backup SQL Server to Google Drive Nowadays Google provides quite cheap storage where you can store your SQL Server database backups. But it isn’t easy to make SQL Server backups directly to Google Drive on a regular basis using T-SQL Commands. However, it is really easy if you are using SqlBak.

How to backup SQL Server to Google Drive

First of all, you need to create a new backup job. To do it go to your Dashboard page and click “Add new job” and then select “Add backup  job”.  How to Backup SQL Server to Google Drive (dashboard)

In the Settings of Backup page select the computer where SQL Server is located and check you SQL Server connections. To continue to job settings press “Continue to job settings”. How to Backup SQL Server to Google Drive (connection)

Check off the databases which you need to backup: How to Backup SQL Server to Google Drive (databases)

Choose the destination where your SQL Server database backups will be stored, to do it press “Add backup destination” in the “Store backups in selected destinations” section. How to Backup SQL Server to Google Drive (add backup destination)

In the Add destination window select “Google Drive”:How to Backup SQL Server to Google Drive (Google Drive)

Click “Authorize” to open the browser and allow SqlBak to access Google Drive: How to Backup SQL Server to Google Drive (Authorize)

Specify a folder on your Google Drive and press “Test” to check your connection, then click “Save & Close” to apply new settings. How to Backup SQL Server to Google Drive (Test)

Finally, set up your backup settings, click “Show advanced backup schedule” and set up the schedule as needed. How to Backup SQL Server to Google Drive (schedule)

Don’t forget to press “Create” to save your backup job.How to Backup SQL Server to Google Drive (create)

It should be noted that you can find more different setting such as Encryption and Compression, E-mail notifications in case of failure or success, as well as add Custom scripts or add some local folders to backup. With the help of all these settings you will be able to tune your backup job just the way you need it.

As you can see it takes about 5 minutes to create SqlBak backup job which will make backups according to your schedule and send them to Google Drive.

[Total: 3    Average: 3/5]

Leave a Reply

Your email address will not be published. Required fields are marked *