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
Last activity: Jun 13, 2022, 03:34 PM