database backup to azure storage container failing

HuuM 46 Reputation points
2021-06-21T17:29:47.567+00:00

Dear fellows,

i am trying to backup on pemised database to azure storage container, but getting this error,

Msg 3271, Level 16, State 1, Line 13
A nonrecoverable I/O error occurred on file "https://abcd.blob.core.windows.net/abcd/abcd_Jun21.bak:" Backup to URL received an exception from the remote endpoint. Exception Message: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel..
Msg 3013, Level 16, State 1, Line 13
BACKUP DATABASE is terminating abnormally.

i have created the credentials and then backing up using the commnad
BACKUP DATABASE abcd
TO URL = N'https://https://abcd.blob.core.windows.net/abcd/abcd_Jun21.bak'
WITH credential = 'SQLBackupsREC';
GO

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Cris Zhan-MSFT 6,601 Reputation points
    2021-06-22T02:14:07.633+00:00

    Hi,

    >Msg 3271, Level 16, State 1, Line 13
    >A nonrecoverable I/O error occurred on

    The error should be related to the credential you used in the backup statement.

    what is your on-premises SQL Server version.

    For 2016 and later, please refer to this doc.
    https://learn.microsoft.com/en-us/sql/relational-databases/tutorial-sql-server-backup-and-restore-to-azure-blob-storage-service?view=sql-server-ver15&tabs=SSMS

    For SQL Server 2014 and prior, use Tutorial: SQL Server 2014 Backup and Restore to Microsoft Azure Blob storage.

    0 comments No comments