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.
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:
How we can restore the backup from bucket in sql server 2019
SQL Server 2019 does not natively support backups or restores directly from Google Cloud Storage (GCS). Only SQL Server 2022 supports this functionality.