Restoring Backup from Block Blob

kevin eckart 26 Reputation points
2020-09-03T12:51:59.72+00:00

Hello, we're using SQL 2017 Enterprise on a 3 nodes AG cluster and successfully backing up our databases to our Azure storage blob using a SAS token. We're uploading as a block blob as expected and can restore that DB to a single server in the AG successfully.

What we're having issues with is restoring the DB simultaneously across all three nodes in the event we need to restore the DB from a backup and have it in sync across 3 nodes. When we run the restore from URL command, first on Node 1, then a few seconds later on Node 2, then again on Node 3; Node 1 continues to restore as expected, but Node 2 and 3 hang and eventually comes back with the error that the file is in use. This is strange because I can do an AZCopy down from the blob to local storage simultaneously across all 3 nodes.

Is this expected behavior? Is there a better way to restore from block blob simultaneously?

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,416 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,638 questions
Accepted answer
  1. deherman-MSFT 33,141 Reputation points Microsoft Employee
    2020-09-03T19:29:48.73+00:00

    @kevin eckart
    Restore always takes a lease on the blob to avoid another operation changing the blob underneath while the restore is happening and to avoid restoring a blob from a backup that is not complete.

    Unfortunately this is by design and is not likely to be changed.

    -------------------

    Please don’t forget to "Accept the answer" and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest