we are using a hub-spoke architecture with the connectivity to on-premises using ExpresRoute. we have a custom DNS server in Hub and both the spoke have a database with private endpoint enable. we want to resolve the private IP of the database from the on-premise.
The issue is Hub VNeT can only be attached to one privatelink.database.windows.net.
how can we attach it to the two same names private DNS zone?
Please suggest.