Backup to URL fails with "nonrecoverable I/O error 3271" in SQL Server

Symptoms
You try to back up a database on your Azure-based SQL Server virtual machine (IaaS) by using the BACKUP DATABASE to URL command. However, the attempt fails with the following error:

Msg 3271, Level 16, State 1, Line 7
A nonrecoverable I/O error occurred on file "
https://sqlbakurl.blob.core.windows.net/backupcontainer/demodb.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 7
BACKUP DATABASE is terminating abnormally.

Cause
This issue occurs if the storage account that you're trying to back up to was created with the Account Kind setting set to Blob. The Account Kind setting should be General Purpose.

General purpose storage account
Resolution
To resolve this issue, create a new storage account, and specify General Purpose for the Account Kind setting. Also, designate a container in this storage account for backup to URL.
More information
When the account kind is set to General Purpose, this provides support for page blob files. SQL Server backup uses page blobs as the Blob type. For more information see SQL Server backup and restore with Windows Azure Blob Storage Service.
Properties

Article ID: 3177997 - Last Review: 08/09/2016 22:52:00 - Revision: 1.0

Microsoft SQL Server 2012 Enterprise, Microsoft SQL Server 2014 Enterprise

  • KB3177997
Feedback