hi team,
i have 2 physical servers with SQL server deployed in a cluster ( shared storage) and not always on.
is it feasible to use azure site recovery to replicate these VMs? because i assume shared storage is not supported on azure.
and what is the procedure to do that?
thanks so much
@eg1995-5273 - You’re correct, using ASR on a shared storage cluster is not supported.
Checking with product owners to see if there is an alternative/workaround to support this scenario.
hi Ahmed,
i found the following link: https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-sql#how-to-help-protect-a-sql-server-cluster
but there isn't additional resources, it just mentions to provision a new on prem SQL server for mirroring and replicating it to ASR. Even failback is not described.
can you advise?
@eg1995-5273 - Sorry for the delayed response!
Azure Site Recovery (ASR) only supports disaster recovery (DR) for standalone SQL server instances. An SQL cluster with shared storage cannot be protected via ASR. No recommendation from ASR. You can setup SQL Always ON for such scenarios.
If the response helped, do "Accept Answer" and up-vote it
yes but in the shared link https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-sql#how-to-help-protect-a-sql-server-cluster
there is a scenario for sql cluster. it is just not explained
Since, it is not a supported scenario, we cannot guide you much on this. Regarding the documentation, if the scenario is mentioned and not explained, you can leverage feedback section to leave a comment on the concern you have.
thank you Sadiqh for you continuous support. I would appreciate if you can give me feedback on a question that i posted 2 weeks ago and i still don;t have an answer. You are one of the most helpful in here. link is below
https://docs.microsoft.com/en-us/answers/questions/753160/migrate-file-server-to-azure-files.html
thanks again
9 people are following this question.
