Trying to backup database from SQL Server 2022 to S3 using S3:// connector but getting an error

Question

Trying to backup database from SQL Server 2022 to S3 using S3:// connector but getting an error

Msg 3201, Level 16, State 1, Line 49
Cannot open backup device 's3://**********.com/sqlservertest/Testing.bak'. Operating system error 12002(failed to retrieve text for this error. Reason: 15100).
Msg 3013, Level 16, State 1, Line 49
BACKUP DATABASE is terminating abnormally.

Completion time: 2022-08-29T11:07:45.4244270-07:00

I have had already set the credentials for the endpoint:

CREATE CREDENTIAL [s3://*************.com/sqlservertest]
WITH
IDENTITY = 'S3 Access Key',
SECRET = '************:****************';

Seeya Xi-MSFT 15,036 Reputation points Microsoft Vendor

2022-09-02T08:31:01.237+00:00

Hi @Jashpinder Singh Gill ,

Hope everything goes well.
The issue seems to be more related to Amazon S3. You can find their support here: https://aws.amazon.com/contact-us/

Best regards,
Seeya
Hugo Queiroz 81 Reputation points Microsoft Employee

2022-09-02T23:45:05.317+00:00

Hi there,

Message error 3201 is usually related to an URL not correctly formed. So chances are you forgot to add the full URL, and I'm assuming your bucketname is "sqlservertest". Where are you trying to backup your database to? Is it on-prem S3 solution or pointing to an s3-storage cloud provider?

You can use both Path style or virtual host for S3 URL, for example:

Path Style:
BACKUP DATABASE AdventureWorks2019
TO URL = 's3://<domainName>/<bucketName>/<pathToBackup>/<backupFileName>';

Virtual Host:
BACKUP DATABASE AdventureWorks2019
TO URL = 's3://<bucketName>.<virtualHost>/<pathToBackup>/<backupFileName>'

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url-s3-compatible-object-storage-best-practices-and-troubleshooting?view=sql-server-ver16

Seeya Xi-MSFT 15,036 Reputation points Microsoft Vendor

2022-09-02T08:31:01.237+00:00

Hi @Jashpinder Singh Gill ,

Hope everything goes well.
The issue seems to be more related to Amazon S3. You can find their support here: https://aws.amazon.com/contact-us/

Best regards,
Seeya
Hugo Queiroz 81 Reputation points Microsoft Employee

2022-09-02T23:45:05.317+00:00

Hi there,

Message error 3201 is usually related to an URL not correctly formed. So chances are you forgot to add the full URL, and I'm assuming your bucketname is "sqlservertest". Where are you trying to backup your database to? Is it on-prem S3 solution or pointing to an s3-storage cloud provider?

You can use both Path style or virtual host for S3 URL, for example:

Path Style:
BACKUP DATABASE AdventureWorks2019
TO URL = 's3://<domainName>/<bucketName>/<pathToBackup>/<backupFileName>';

Virtual Host:
BACKUP DATABASE AdventureWorks2019
TO URL = 's3://<bucketName>.<virtualHost>/<pathToBackup>/<backupFileName>'

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url-s3-compatible-object-storage-best-practices-and-troubleshooting?view=sql-server-ver16

Answer 1

Hi @Jashpinder Singh Gill ,

Welcome to Microsoft Q&A!

Operating system error 12002(failed to retrieve text for this error. Reason: 15100)

If you have received this error 12002 on your PC, it means that there was a malfunction in your system operation. Error code "error 12002" is one of the issues that users may get as a result of incorrect or failed installation or uninstallation of software that may have left invalid entries in system elements. Other potential causes may include improper system shutdown, such as due to a power failure, someone with little technical knowledge accidentally deleting a necessary system file or system element entry, as well as a number of other factors.

The following steps should help fix the issue:
Download Outbyte PC Repair application
Install and launch the application
Click the Scan Now button to detect potential issue causes
Click the Repair All button to fix detected abnormalities
The same application can be used to run preventative measures to reduce the chance of this or other system issues appearing in the future.

Best regards,
Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Erland Sommarskog 72,251 Reputation points MVP

2022-08-30T21:05:13.233+00:00

Seeya, are you confident that you answer is on the mark? Jashpinder is trying to back up to a cloud service, and you think that his PC is in need of repair when that results in an error?
Jashpinder Singh Gill 1 Reputation point

2022-08-31T07:01:42.32+00:00

Precisely, what I wanted to say as well.
So I have a win server 2019 with SQL Server preview 2022 and SSMS 19 installed.

I am trying to create a credential for the cloud object storage first , which gets created.

But the problem lies with the backup or a general connectivity to the S3 Object Storage using the s3:// connector.

Answer 2

Jashpinder Singh Gill 1

I was able to resolve it by getting a valid signed TLS certificate from the S3-Object Storage and loading it inside the Trusted Root Certificate Authority within the SQL Server Windows OS.
This Thread may be closed

Dan Guzman 7,121 Reputation points

2022-09-06T11:10:33.543+00:00

@Jashpinder Singh Gill , consider marking this as the answer to your own question for visibility. This will help others with the same problem.

Trying to backup database from SQL Server 2022 to S3 using S3:// connector but getting an error

2 answers

Activity