Sample Header Ad - 728x90

BACKUP LOG failed to write to Azure Blob

0 votes
0 answers
137 views
We have a SQL VM running out of Azure with SQL Agent jobs running BACKUP LOG every x hours to Azure Blob. These jobs have been running fine for a long time until recently. We keep getting the below error and these jobs fail intermittently for various databases. They don't always fail at their scheduled run. If it fails, I can re-run the job manually like two minutes later without any issue. I have looked up online and haven't found a solution to my problem. Does anyone know why and how I can fix this? Any help is appreciated. -------- Message Executed as user: DSN\xyz. Write on "https://xyz.blob.core.windows.net/CW_Data_LOG_06102022_140000.TRN " failed: 13(The data is invalid.) [SQLSTATE 42000] (Error 3202) BACKUP LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Asked by sydney (167 rep)
Jun 13, 2022, 03:12 PM
Last activity: Jun 13, 2022, 03:34 PM