GCP Cloud VM, SQL SERVER 2019 Enterprise Edition, Database, Backup Direct to GCP Bucket !

[navneet_3b]

in environment, we are using the GCP VM and Have installed the SQL SERVER 2019 enterprise Edition, while taking the backup - we want FULL /Diff / Log Backup, Directly  the backup from  sql server is taken to GCP  Bucket (using GCP URL ) ... But find any solution, Please Help? 

and also can be restore that  backup  (.bak), when ever it required !  

Backup files (.bak, .trn, .log) should be created at GCP bucket direct with T-SQL Command. 

[ms4446 · Accepted solution]

SQL Server 2019 does not support backing up to Google Cloud Storage (GCS). However, SQL Server 2022 does support backing up to GCS.

To backup a SQL Server database to GCS in SQL Server 2022, you can use the BACKUP DATABASE command with the TO URL option. The following is an example of a T-SQL script that you can use to backup a database to GCS:

USE master;
GO

BACKUP DATABASE [database_name]
TO URL = 'gs://GCS_BUCKET_NAME/backups/database_name.bak'
WITH FORMAT
GO

Sure, here is a new response that states SQL Server 2019 does not support backing up to GCS, but mentions that SQL Server 2022 does support backing up to GCS:

Does SQL Server 2019 support backing up to GCS?

No, SQL Server 2019 does not support backing up to Google Cloud Storage (GCS). However, SQL Server 2022 does support backing up to GCS.

To backup a SQL Server database to GCS in SQL Server 2022, you can use the BACKUP DATABASE command with the TO URL option. The following is an example of a T-SQL script that you can use to backup a database to GCS:

SQL

USE master;
GO

BACKUP DATABASE [database_name]
TO URL = 'gs://GCS_BUCKET_NAME/backups/database_name.bak'
WITH FORMAT
GO

For more information on how to backup a SQL Server database to GCS in SQL Server 2022, please see the following links:

• SQL Server Backup to URL S3-compatible Object Storage
• Back Up Directly to a GCS Bucket in SQL Server 2022

[deepak_mi]

How we can restore the backup from bucket in sql server 2019

[ms4446]

SQL Server 2019 does not natively support backups or restores directly from Google Cloud Storage (GCS). Only SQL Server 2022 supports this functionality.