Forum Discussion
Backing up database from SQL server 2017 to Azure Blob container
Hi All, just wondering if I can get some assistance with an issue that I am having. I am trying to setup backup to URL in SSMS to Azure. I have created the credentials and the subplan and it would backup ok on the first day with no errors, however on the second day I would get the following error: Failed:(-1073548784) Executing the query "BACKUP DATABASE [SQLDB] TO URL = N'https:..." failed with the following error: "A nonrecoverable I/O error occurred on file "URL: https://azstorage.blob.core.windows.net/Storage/SQLDB_backup_2023_11_23_003000_3611749.bak:"Backup to URL received an exception from the remote endpoint. Exception Message: Unable to connect to the remote server. BACKUP DATABASE is terminating abnormally. I have tried dropping and recreating credentials, windows host server and SSMS are up to date (SQL 2017), installed latest cumulative updates, created a different storage account.