SQL DB Restore On Azure SQL VM directly from BLOB container

Afzal Atique 21 Reputation points
2020-06-04T18:02:15.94+00:00

I have a SQL DB backup of 3 TB, because of the huge DB we have taken split backup into three files. These are copied to azure BLOB storage
File1.bak
File2.bak
File3.bak

While trying to restore directly from Blob, there is error
Msg 3294, Level 16, State 1, Line 1
Use of the URL device type is limited to a single device during Backup and Restore operations.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Question : Is it supported ? Can we restore from blob when backup is split into multiple files ?

PS : we also copied the backup into file share in azure and restore from that worked.

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Navtej Singh Saini 4,216 Reputation points Microsoft Employee
    2020-06-05T21:58:19.677+00:00

    Hi @Afzal Atique

    There are definitely restriction there as troubleshooted in this document.

    Here are some of other restrictions that you may face - Limitations. Also here is a document to handle larger DB with different methods rather than dividing it into different files.

    Hope this helps. Also to get better help from community, post here for your SQL Server IaaS questions. This is a forum for Azure SQL PaaS offerings.

    Thanks

    Navtej S

    Disclaimer - MS is not responsible for the validity of documentation on external links.

    0 comments