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”, choose “Backup job” at the “Job type” box and click on the “Create job”.
At the backup job settings page, select the server where SQL Server is located and check the SQL Server connections.
Check off the databases that you need to backup at the “Select databases” section.
Choose the destination where your SQL Server database backups will be stored, to do it press “Add destination…” in the “Store backups in 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 job schedule, click “Advanced settings” and set up the schedule as needed.
Don’t forget to press “Save & Exit” to save your backup job settings.
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 the SqlBak backup job that will make backups according to your schedule and send them to Google Drive.