<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: SQL Managed Instance Failover Within Region in Network Security Discussions</title>
    <link>https://live.paloaltonetworks.com/t5/network-security-discussions/sql-managed-instance-failover-within-region/m-p/1420913#M894</link>
    <description>Hi @RossSmith , thank you for starting this conversation in the community! I spoke to some ofmy teammates at Venafi that this question leans heavy on the Microsoft side. Its not ideal to point you elsewhere, but you might have better luck starting a thread in the Azure Community:https://azure.microsoft.com/en-us/support/community  Ill keep this thread open in case other customers are able to jump in to share how theyve found a solution for a similar use case.</description>
    <pubDate>Mon, 10 Jul 2023 11:34:20 GMT</pubDate>
    <dc:creator>CyberArkAlumni</dc:creator>
    <dc:date>2023-07-10T11:34:20Z</dc:date>
    <item>
      <title>SQL Managed Instance Failover Within Region</title>
      <link>https://live.paloaltonetworks.com/t5/network-security-discussions/sql-managed-instance-failover-within-region/m-p/1420912#M893</link>
      <description>Hey All,We are setting up Azure SQL Managed instances for the Venafi TPP product, and looking into the failover options available to mimic SQL Always On requirements in the design docs.We have built two SQL managed instances as Business Critical, but failover seems to be only available between two regions, not within zones of a single region. There is an option referred to as Zone Redundancy online but this is not available in the wizard, and shows in the export template as False by default, we are experimenting with a custom ARM template to try and turn this on.For Failover groups requirements, we have ensured that the DNS-prefix matches, by specifying the primary server upon building the secondary and they are a match in size, but they are not valid options in the drop down of Secondary Managed instance when configuring.Appreciate this may be more of an Azure question and we are investigating down that route as well, but as its to make a Venafi TPP compatible database solution, has anyone tried something similar with Azure SQL Managed Instances, and been able to accomplish this or something similar?Thanks,Ross.</description>
      <pubDate>Fri, 23 Jun 2023 15:42:14 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/network-security-discussions/sql-managed-instance-failover-within-region/m-p/1420912#M893</guid>
      <dc:creator>RossSmith</dc:creator>
      <dc:date>2023-06-23T15:42:14Z</dc:date>
    </item>
    <item>
      <title>Re: SQL Managed Instance Failover Within Region</title>
      <link>https://live.paloaltonetworks.com/t5/network-security-discussions/sql-managed-instance-failover-within-region/m-p/1420913#M894</link>
      <description>Hi @RossSmith , thank you for starting this conversation in the community! I spoke to some ofmy teammates at Venafi that this question leans heavy on the Microsoft side. Its not ideal to point you elsewhere, but you might have better luck starting a thread in the Azure Community:https://azure.microsoft.com/en-us/support/community  Ill keep this thread open in case other customers are able to jump in to share how theyve found a solution for a similar use case.</description>
      <pubDate>Mon, 10 Jul 2023 11:34:20 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/network-security-discussions/sql-managed-instance-failover-within-region/m-p/1420913#M894</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2023-07-10T11:34:20Z</dc:date>
    </item>
    <item>
      <title>Re: SQL Managed Instance Failover Within Region</title>
      <link>https://live.paloaltonetworks.com/t5/network-security-discussions/sql-managed-instance-failover-within-region/m-p/1420914#M895</link>
      <description>Hi Sofia, thanks for the reply. I have made progress with this since originally posting, it turns out that BC SQL MI is already configured for failover but it is not easily visible from within Azure. Following this article I was able to monitor the SQL primary and secondary instances in TSQL and force a manual failover via Azure Powershell to prove it worked. So it seems that the only requirement is the change to Business Critical and its all done for you. Creating a failover group would provided failover on failover, and we do not need this level or resilience. Might help someone in the future, so thought I would provide details. Manually initiate a failover on SQL Managed Instance - Azure SQL Managed Instance | Microsoft Learn</description>
      <pubDate>Tue, 11 Jul 2023 01:27:39 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/network-security-discussions/sql-managed-instance-failover-within-region/m-p/1420914#M895</guid>
      <dc:creator>RossSmith</dc:creator>
      <dc:date>2023-07-11T01:27:39Z</dc:date>
    </item>
  </channel>
</rss>

