Posts

Showing posts with the label SQL BackuptoURL

SQL Server backup to URL no mechanism to retry on backup errors Msg 3013, Level 16, State 1, Server, Line 1

Running Microsoft SQL Server 2016 (SP2-CU2) 13.0.5153.0 and below I can confirm that in August of 2018 there is currently no retry logic for Backup to URL.  If you use Backup To URL functionality natively or in conjunction with Ola Hallengren scripts   any blip, transient network issue/failure, or even Blob service issues/throttling during the backup process will cause a high level generic error failure code.  These errors are random at best, but the product unfortunately is working as designed and expected as retry logic is not currently built into the Backup To URL functionality.  It would be extremely beneficial and I would welcome the addition in any and all future SQL versions. Backup to URL was a new feature introduced in SQL Server 2012 so it has been around for 5+ years.  While this was a new feature, I would say very few truly use this even today.  If you are running an environment that is 100% Azure based then I feel that this is a feature tha...