A Nonrecoverable I/O error occurred – when restoring the database from a Cloud URL in SQL 2014

When restoring the database from a cloud URL there is a chance you will encounter the below error.

Msg 3271, Level 16, State 1, Line 1

A nonrecoverable I/O error occurred on file “https://ebsclouddbstore.blob.core.windows.net/mssqlbakups/madworks_backup_2015_01_13_134617.bak:” Backup to URL received an exception from the remote endpoint. Exception Message: Error occurred while referencing Blob in remote storage.

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

In this case the most common reason is the backup file doesn’t exists on the Cloud storage , check the path is correct , check if the file exists on the blob storage account.

Please Consider Subscribing

Leave a Reply