BACK UP SQL TO GOOGLE CLOUD STORAGE
SQL Backup Master can be configured to back up your Microsoft SQL Server databases to Google Cloud Storage through their S3 compatible service endpoint.
Google Cloud Storage is a powerful and scalable object storage solution, making it an excellent choice for housing your critical SQL Server backups. To provide maximum flexibility, SQL Backup Master connects to Google Cloud Storage by leveraging its S3 interoperability API. This allows our robust and feature-rich S3 backup destination to work directly with your Google Cloud Storage buckets.
The authentication process is straightforward but distinct from other Google services. To get started, you will need to generate HMAC (Hash-based Message Authentication Code) keys from within your Google Cloud project. This is a special key type that Google provides specifically for S3 compatibility. The HMAC key consists of two parts:
- An Access ID: This is entered into the "Access Key" field in SQL Backup Master.
- A Secret: This is entered into the "Secret Key" field in SQL Backup Master.
As shown in the screenshot, you simply select the "S3 Compatible" destination type and use storage.googleapis.com as the service endpoint URL. Once your credentials are in place, you can select your target bucket and begin performing automated, scheduled backups of your SQL databases directly to Google Cloud Storage. This method combines the proven reliability of our S3 integration with the global infrastructure and performance of the Google Cloud Platform.
Related article: How to back up SQL Server databases to Google Cloud Storage