How to fix SQL backup to URL error: The remote server returned an error: (400) bad request
![](https://www.pythian.com/hubfs/Imported_Blog_Media/Untitled-1.jpg)
Problem:
You are trying to take a native SQL Backup to URL and you receive the error below:Msg 3271, Level 16, State 1, Line 1 A nonrecoverable I/O error occurred on file "https://MyStorageAccount.file.core.windows.net/MyContainer/Adventureworks_full_20190420.bak:" Backup to URL received an exception from the remote endpoint. Exception Message: The remote server returned an error: (400) Bad Request.. Msg 3013, Level 16, State 1, Line 1 BACKUP DATABASE is terminating abnormally.
Cause:
You are trying to save a blob file using to non-blob storage or not using the Blob storage endpoint. Check your URL to see if you are pointing to the correct one. SQL Server backups can only be saved to Blob storage. If you are using general purpose storage, you will have multiple endpoints for different usage. You should be using the Blob url for SQL backups - see from the picture below. The one in the green box is the Blob storage endpoint. Using any other endpoints would result in a Bad Request Error. The same is true when using the other endpoints. You should be using it for the correct file types.![](https://www.pythian.com/hs-fs/hubfs/Imported_Blog_Media/Untitled-1.jpg?width=1379&height=836&name=Untitled-1.jpg)
Fix:
Review the url path you are trying to restore to and make sure you are using the correct endpoint for Blob Storage.Share this
You May Also Like
These Related Stories
Installing Forms 12.2.1.4 – File not found $ORACLE_HOME/lib/libvsn12_ee.a.dbl using GUI
![](https://www.pythian.com/hubfs/Imported_Blog_Media/shutterstock_2079696961-scaled.jpg)
Installing Forms 12.2.1.4 – File not found $ORACLE_HOME/lib/libvsn12_ee.a.dbl using GUI
Feb 1, 2022
2
min read
How to work around OMS 12.1.0.3 error: Metric evaluation error start – Get dynamic property error
How to work around OMS 12.1.0.3 error: Metric evaluation error start – Get dynamic property error
Sep 30, 2019
2
min read
Change Port Number in Common Object Service (COS) Naming Service for Reports Server Discovery
Change Port Number in Common Object Service (COS) Naming Service for Reports Server Discovery
Mar 30, 2021
2
min read
No Comments Yet
Let us know what you think