Sample Header Ad - 728x90

Backup SQL transaction log to Azure "append blob"?

0 votes
0 answers
133 views
We have long saved our hourly transaction log backups throughout the day by starting a new t-log file nightly, after the full backup is complete, and then appending to it hourly for the rest of the day. Recently I have moved the nightly full backups to Azure blob storage which is working great, but the t-logs write the first file and after that are not able to append. 1 minute of googling confirmed that append is *not* supported on either block blobs nor page blobs (I had already tried it both ways to no avail) but also showed that there is a third type of blob, the Append Blob. That sure sounds like the ticket! But I can't figure out how to specify which type of blob to use. To switch between Block Blob and Page Blob I change which credential is being used (SAS token or shared key) but not sure how to use Append Blob, or whether that's just plain not supported for SQL backups. I'm guessing it comes down to how the initial blob/file is created, but have yet to find any info online about whether what I'm trying to do there is possible or not. This is MS SQL Server 2022 and the backup is currently performed by an agent job, not a maint plan.
Asked by OKreboots (1 rep)
Sep 17, 2023, 06:32 PM
Last activity: Sep 19, 2023, 02:09 AM