Azure SQL Database
An Azure relational database service.
6,312 questions
Please read support article "Import Export using Private Link now in Preview". All you need to know is in that article.
Azure SQL database manual backup to blob- via private link
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 42%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Ashwan
536
Reputation points
Hi we have Azure SQL databases(on private network) and looking to database backup(BACKUP database dbname to URL ... ) and restore in to other Azure env(lets says prod database to test env database) . can we do this using BLOB option ( private network) not in exposed to public
any one can explain it whether possible or not. if this is impossible , then how do we clone the databases to prod to non prod env
any one can reply would be great help
Azure SQL Database
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SSingh-MSFT 16,371 Reputation points Moderator2022-12-08T05:12:30.54+00:00 Hi @Ashwan ,
Following up to see if the below suggestion was helpful. If this answers your query, do click
Accept AnswerandUp-Votefor the same. And, if you have any further query do let us know.
Sign in to comment
2 answers
Sort by: Most helpful
-
Alberto Morillo 34,666 Reputation points MVP Volunteer Moderator2022-12-07T03:26:14.773+00:00 -
Ashwan 536 Reputation points
2022-12-07T03:54:34.397+00:00 hi @Alberto Morillo thanks for that ? Do we have any other option like
BACKUP database userdb
to URL = 'https://wwibackupstorage.blob.core.windows.core.windows.net/backup/fmedb.bak' with copy_only,compression, checksum,status =5and restore?
thanks
-
Alberto Morillo 34,666 Reputation points MVP Volunteer Moderator
2022-12-07T04:03:02.16+00:00 Native SQL Server backups are not available on Azure SQL, you use bacpacs instead. Azure SQL Managed Instance does allow backup to URL.
Sign in to comment -