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”.
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”.
Check off the databases which you need to backup:
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.
In the Add destination window select “Google Drive”:
Click “Authorize” to open the browser and allow SqlBak to access Google Drive:
Specify a folder on your Google Drive and press “Test” to check your connection, then click “Save & Close” to apply new settings.
Finally, set up your backup settings, click “Show advanced backup schedule” and set up the schedule as needed.
Don’t forget to press “Create” to save your backup job.
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.