Cannot backup SQL server db with private endpoint link to azure blob storage

Kanishka Perera 0

Hello,

As I have mentioned on above title, we are trying to backup our database to blob storage using publicly available Runbook from run book gallery (Backup Azure SQL Databases to Blob storage Runbook by josegomera). We were able to get the backup up and running after enabling "Public Access" and "Allow azure services and resources" from SQL server > Networking.

But we are trying to do it from private link without actually enabling the "Public Access" and "Allow azure services and resources" from networking section.

If we were to add the private link from export section in database and approve it from Private Link Center, it will work. But if we have the private link from Runbook it won't.

May be the Runbook is not configured to take backups with private link..? If not, do we have any workarounds..? to take backups without enabling "Public Access" and "Allow azure services and resources"..?

TP 95,211 Reputation points

2024-09-10T06:25:41.8966667+00:00

Your question was deleted by the spam filter. I restored it.
Mahesh Kurva 240 Reputation points Microsoft Vendor

2024-09-11T09:12:34.1533333+00:00
Hi @Kanishka Perera,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

Workaround for Azure Automation Runbooks:

Azure Automation Runbook cloud jobs cannot directly access Azure resources secured using private endpoints.

To work around this, use a Hybrid Runbook Worker instead. Hence, on-premises VMs are supported to run Hybrid Runbook Workers against an Automation Account with Private Link enabled.

Also, remember that when you create a Private Link this endpoint is a private endpoint within a specific VNet and Subnet. If you try to connect outside this VNet and Subnet the connection will be using the public endpoint.

For more information please refer: Limitations.

I hope this is helpful, do let us know if you any further quires.
Mahesh Kurva 240 Reputation points Microsoft Vendor

2024-09-12T12:04:58.53+00:00

Hi @Kanishka Perera,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Mahesh Kurva 240 Reputation points Microsoft Vendor

2024-09-13T11:54:39.6233333+00:00

Hi @Kanishka Perera,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

Cannot backup SQL server db with private endpoint link to azure blob storage

Your answer