Azure App Service Team Blog

How the App Service team functions

My Backups are failing, Let’s open a support ticket

Actually wait!

A big percentage of the backup failures (More than 42%) can be fixed in minutes, and more importantly without even opening a support ticket.

Step 1: Figure out what is the failure.

From the backup blade, click on the failing backup and check the Log Details

Step 2: Check the following table.

Error Fix
Storage access failed. {0} Delete backup schedule and reconfigure it
The website + database size exceeds the {0} GB limit for backups. Your content size is {1} GB. Use a backup.filter file to exclude some files from the backup, or remove the database portion of the backup and use externally offered backups instead https://aka.ms/partial-backup
Error occurred while connecting to the database {0} on server {1}: Authentication to host ‘{1}’ for user ‘<username>’ using method ‘mysql_native_password’ failed with message: Unknown database ‘<db name>’ Update database connection string
Cannot resolve {0}. {1} (CannotResolveStorageAccount) Delete backup schedule and reconfigure it
Login failed for user ‘{0}’. Update database connection string
Create Database copy of {0} ({1}) threw an exception. Could not create Database copy Use admin user in connection string
The server principal “<name>” is not able to access the database “master” under the current security context. Cannot open database “master” requested by the login. The login failed. Login failed for user ‘<name>’. Use admin user in connection string
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) Check that the connection string is valid, whitelist site’s outbound IPs in database server settings
Cannot open server “<name>” requested by the login. The login failed. Check that the connection string is valid
Missing mandatory parameters for valid Shared Access Signature Delete backup schedule and reconfigure it
SSL connection is required. Please specify SSL options and retry. when trying to connect Please use the built in backup feature in Azure MySQL or Azure Postgressql.


Step 3:
The failure is not in the table


Well … Please open a support ticket.