commvault.com commvault.com
Question

NetApp Intellisnap and Microsoft SQL Always On Cluster

  • 14 October 2022
  • 8 replies
  • 92 views
V
Rank
Badge

Hi Experts,

is there somewhere a best practicse guide for “How to backup MS SQL Always On Cluster with Intellisnap” ?
Is this supportet from CommVault?

Should we do only a snaps from the replica?

Thank you in advanced.

Best,

Volker
 

8 replies

S
Rank
Userlevel 6
Badge +14

Hello @VolkerJ

Yes that config is supported. The config setup is the same as any other client and or setup. However,

for AlwaysOn Cluster you would want to set backup preference to primary replica as noted here:

https://kb.commvault.com/article/54167

Also note that for restore you would want to leverage a proxy for restores

https://documentation.commvault.com/2022e/expert/92447_intellisnap_best_practices_sql_server_agent.html

Transaction log backups will still be performed via SQL VDI API. That and some other info noted in the FAQ
https://documentation.commvault.com/2022e/expert/34617_intellisnap_faq_sql_server_agent.html

S
Rank
Badge +3

Hi,

thanks for the answer @Scott Reynolds.

Is that written down in BOL (Docs) anywhere as “official statement” that IntelliSnap is supported as backup method for SQL DBs running in a Always On Cluster?

Maybe it could be added to the FAQ.

 

Many thanks

Julian

S
Rank
Userlevel 6
Badge +14

@skoomer Its not clearly stated that its supported. This is something we will look into, thanks for the feedback.

S
Rank
Badge +3

Hi @Scott Reynolds 

 

many thanks for the quick response.

I found the following in BOL.

https://documentation.commvault.com/2022e/expert/37179_platforms.html

What is meant by “AG” - Always On availability group?
That would mean that IntelliSnap is supportet for “Always On Cluster”.

 

Kind regards

Julian

S
Rank
Userlevel 6
Badge +14

Yes, that is correct.


AG = short for AlwaysOn Availability Group 

S
Rank
Badge +3

Ok, so does that mean, that it’s supported to backup SQL DBs in an AG (Always On Cluster) via IntelliSnap?

Is that the “official statement”?

Everything I find in BOL is very confusing…

 

S
Rank
Userlevel 6
Badge +14

Yes, its supported as noted above in my original post and your screenshot and link as well.

https://documentation.commvault.com/2022e/expert/37179_platforms.html

SQL 2005 and later (Database Engine only - including AG environments)

S
Rank
Badge +3

@skoomer Its not clearly stated that its supported. This is something we will look into, thanks for the feedback.

Ok, cool.

I was just a little bit confused because you wrote “Its not clearly stated that its supported”.

 

Reply


Terms & ConditionsCookie settings