Hi Team, In Support matrix for SQL Server Backup in Azure VMs its mention that " SQL Server Failover Cluster Instance (FCI) isn't supported" Is there any alternative????

Ashish Kumar Ranjan 41 Reputation points
2020-08-10T12:12:22.08+00:00

Hi Team,

In Support matrix for SQL Server Backup in Azure VMs its mention that "
SQL Server Failover Cluster Instance (FCI) isn't supported"

Is there any alternative????

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,174 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Kumar Ranjan 41 Reputation points
    2020-08-10T17:57:06.28+00:00

    @SadiqhAhmed-MSFT
    Hey there do you have any good news for me..........

    A short story of my issue....we are doing As-Is migration and right now we are using WFSC FCI in our on-premise environment and we are migrating to Azure..So for the Backup of VM and SQL we opt the Azure Backup but after sometime we get to know that its not being supported so here the pause came to our migration so thats why I reached you guys to find any alternative/workaround........

  2. SadiqhAhmed-MSFT 40,441 Reputation points Microsoft Employee
    2020-08-12T12:47:39.88+00:00

    Sorry for the delay in response to your post.

    Using DPM 2019 UR2 you can protected SQL Server FCI instance deployed on Azure. There are ways using which you can get shared storage for deploying SQL FCI instance in Azure.

     Using Storage Space Direct (S2D) – DPM 2019 UR2 supports backup SQL FCI instance using this method.

     Premium File Shares – DPM (any version0 doesn’t support backup of SQL Database stored on the file share.

    Here is the article on SQL Protection using DPM - https://video2.skills-academy.com/en-us/system-center/dpm/back-up-sql-server?view=sc-dpm-2019

    ------------------------------------------------------------------------------------------------------------------------------

    Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

    0 comments
  3. Ashish Kumar Ranjan 41 Reputation points
    2020-08-12T17:00:41.05+00:00

    @SadiqhAhmed-MSFT ......Thanks for the information much appreciated....just to clarify here that...I have window server 2012R2
    ...and SQL SERVER 2014 and for the production environment we are have 4 node fci cluster....and we have build this cluster with the help of Azure Premium File share.....is it possible to use DPM 2019 and it will work for me????????