question

AfzalAtique-1478 avatar image
0 Votes"
AfzalAtique-1478 asked azure-cxp-api edited

SQL DB Restore On Azure SQL VM directly from BLOB container

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
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

backup of on-prem server was taken using native sql backup.
and trying to restore this native backup to azure SQL VM

0 Votes 0 ·

@AfzalAtique-1478
Please convey if you have any further questions. If this information helped you , please mark the reply as an answer below so the issues closes and others can get help from the same.
Navtej S

0 Votes 0 ·

1 Answer

NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered NavtejSaini-MSFT edited

Hi @AfzalAtique-1478

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.