フェールオーバークラスターマネージャーでSQL Server Always On 可用性グループのリソースを操作する際の注意事項

Published Feb 09 2022 07:16 PM 912 Views
Microsoft

こんにちは、 SQL Server サポートチームです。 

本記事では SQL Server Always On 可用性グループ (以下、AG) を構成している場合に、フェールオーバークラスターマネージャー の操作で注意するべき点をご紹介します。 

  

AG の同期はプライマリレプリカとセカンダリレプリカの間でトランザクションログを転送することで実現しており、同期モードや同期状態などは SQL Server インスタンスで管理しています。 

WSFC では AG の同期状態などを保持していないため、AG  WSFC リソースをフェールオーバークラスターマネージャーから操作することは基本的にサポートされていません。 

AG のフェールオーバーや同期モード変更などの操作は、SQL Server インスタンスに対して SQL Server Management Studio  GUI やクエリで実施する必要があります。 

SQL Server インスタンスは操作された内容をもとに WSFC リソースの設定変更やフェールオーバーを実行します。 

  

例として、WSFC リソースの「実行可能な所有者」のプロパティは、 AG のレプリカが自動フェールオーバーする設定の場合はチェックが入り、自動フェールオーバーしない(手動フェールオーバー)の場合はチェックが入らないように構成されます。 

そのため、フェールオーバークラスターマネージャーから直接設定を変更することは想定されておらず、もし変更した場合は予期せぬ動きが発生する可能性があります。 

また、クラスター検証レポートでは AG の同期設定などを考慮しないため自動フェールオーバーしない設定の場合に下記の警告が記録されることが想定されますが、フェールオーバークラスターマネージャーを操作して実行可能な所有者にチェックを入れる必要はありません。 

  

■警告の例 

このリソースに、実行可能な所有者として一覧表示されているクラスターのノードのうち不足しているノードがあります。このリソースがメンバーであるクラスター化された役割は、実行可能な所有者の一覧に含まれないノード上で開始することはできません。 

 

Yuki_Kitazawa_4-1644462742045.png

 

■手動フェールオーバー時の画面例 

・可用性グループのプロパティ    (手動フェールオーバー)

Yuki_Kitazawa_0-1644462658660.png

 

WSFCの可用性グループリソースのプロパティ (手動フェールオーバー)

Yuki_Kitazawa_1-1644462658658.png

 

■自動フェールオーバー時の画面例 

・可用性グループのプロパティ (自動フェールオーバー)

Yuki_Kitazawa_2-1644462658662.png

 

WSFCの可用性グループリソースのプロパティ (自動フェールオーバー)

Yuki_Kitazawa_3-1644462658663.png

 

 

フェールオーバークラスターマネージャーを使用した AG の操作に関する制限事項は、下記の Docs を参照ください。 

  

WSFC フェールオーバー クラスター マネージャーを使用した可用性グループの操作に関する制限事項 

https://docs.microsoft.com/ja-jp/sql/database-engine/availability-groups/windows/failover-clustering... 

  

Always On 可用性グループの前提条件、制限事項、推奨事項 

https://docs.microsoft.com/ja-jp/sql/database-engine/availability-groups/windows/prereqs-restriction... 

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3146787%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Bja-JP%5C%26quot%3B%22%3ENotes%20when%20working%20with%20SQL%20Server%20Always%20On%20Availability%20Group%20resources%20in%20failover%20cluster%20manager%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3146787%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Bja-JP%5C%26quot%3B%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EHello%2C%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20this%20is%20the%20SQL%20Server%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Esupport%20team.%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EThis%20article%26lt%3B%5C%2FSPAN%26gt%3B%20introduces%20some%20things%20%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20%26lt%3B%5C%2FSPAN%26gt%3B%20to%20keep%20in%20mind%20when%20working%20with%20Failover%20Cluster%20Manager%20when%20configuring%20%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20sql%20server%20always%20on%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Eavailability%20groups%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20(%26lt%3B%5C%2FSPAN%26gt%3BAG%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E).%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EAG%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Esynchronization%20is%20achieved%20by%20transferring%20transaction%20logs%20between%20the%20primary%20and%20secondary%20replicas%2C%20and%20the%20SQL%20Server%20instance%20manages%20synchronization%20mode%2C%20synchronization%20status%2C%20and%20so%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Eon.%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EBecause%20%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EWSFC%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Edoes%20not%20maintain%20the%20synchronization%20state%20of%20the%20AG%2C%20it%26lt%3B%5C%2FSPAN%26gt%3B%20is%20basically%20not%20supported%20to%20work%20with%20the%20%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EAG's%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20WSFC%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Eresources%20from%20the%20failover%20cluster%20manager.%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EOperations%20such%20as%20AG%20failover%20and%20synchronization%20mode%20changes%20must%20be%26lt%3B%5C%2FSPAN%26gt%3B%20performed%20%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Eon%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20SQL%20Server%20Management%20Studio%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20GUI%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Eand%20queries%20on%20SQL%20Server%20instances.%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3ESql%20Server%20%26lt%3B%5C%2FSPAN%26gt%3B%20instances%20change%20settings%20and%20failover%20%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20WSFC%20%26lt%3B%5C%2FSPAN%26gt%3B%20resources%20%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Ebased%20on%20what%26lt%3B%5C%2FSPAN%26gt%3B%20%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Ethey%20have%20interacted%20with.%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EAs%20an%20example%2C%26lt%3B%5C%2FSPAN%26gt%3B%20%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Ethe%20%22executable%20owner%22%20property%20of%20a%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EWSFC%20%26lt%3B%5C%2FSPAN%26gt%3B%20resource%20is%20%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Econfigured%20to%20be%20checked%20if%20the%20AG%20replica%20is%20set%20to%20auto-fail%20over%2C%20and%20not%20if%20it%20is%20not%20auto%20failover%20(manual%20failover).%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3ETherefore%2C%20it%20is%20not%20expected%20to%20change%20the%20settings%20directly%20from%20the%20failover%20cluster%20manager%2C%20and%20if%20you%20do%2C%20unexpected%20movements%20may%20occur.%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EAlso%2C%20because%20the%20cluster%20validation%20report%26lt%3B%5C%2FSPAN%26gt%3B%20%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Edoes%20not%20take%20into%20account%20the%20synchronization%20settings%20of%20the%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20AG%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bnone%5C%26quot%3B%22%3E%2C%26lt%3B%5C%2FSPAN%26gt%3B%20%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Eit%20is%20assumed%20that%20the%20following%20warning%20will%20be%20recorded%20in%20case%20of%20a%20configuration%20that%20does%20not%20auto%20fail%20over%2C%20but%20you%20do%20not%20need%20to%20check%20the%20executable%20owner%20by%20manipulating%20the%20failover%20cluster%20manager.%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%E2%96%A0%20Warning%20example%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CI%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EThis%20resource%20contains%20missing%20nodes%20in%20the%20cluster%20listed%20as%20executable%20owners.%20Clustered%20roles%20with%20which%20this%20resource%20is%20a%20member%20cannot%20start%20on%20nodes%20that%20are%20not%20in%20the%20list%20of%20possible%20owners.%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FI%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346916iFDDA718C30819006%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Yuki_Kitazawa_4-1644462742045.png%22%20alt%3D%22%5C%26quot%3BYuki_Kitazawa_4-1644462742045.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%E2%96%A0%20Screen%20example%20during%20manual%20failover%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EAvailability%20group%20properties%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%20%3CSPAN%3E%20(Manual%20failover)%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346912iE8DE06664ACE14E2%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Yuki_Kitazawa_0-1644462658660.png%22%20alt%3D%22%5C%26quot%3BYuki_Kitazawa_0-1644462658660.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EWSFC%26lt%3B%5C%2FSPAN%26gt%3B%20%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Eavailability%20group%20resource%20properties%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%20(manual%20failover)%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346913i61889CC0A533C359%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Yuki_Kitazawa_1-1644462658658.png%22%20alt%3D%22%5C%26quot%3BYuki_Kitazawa_1-1644462658658.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%E2%96%A0%20Screen%20example%20during%20automatic%20failover%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EAvailability%20group%20properties%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%20(automatic%20failover)%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346914i4868DE64565BFAB7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Yuki_Kitazawa_2-1644462658662.png%22%20alt%3D%22%5C%26quot%3BYuki_Kitazawa_2-1644462658662.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EWSFC%26lt%3B%5C%2FSPAN%26gt%3B%20%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Eavailability%20group%20resource%20properties%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%20(automatic%20failover)%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%5C%26quot%3Blia-inline-image-display-wrapper%22%20lia-image-align-inline%3D%22%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fgxcuf89792%2F%5C%26quot%3Bhttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346915i74211AF435F14FCD%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%5C%26quot%3B%22%20role%3D%22%5C%26quot%3Bbutton%5C%26quot%3B%22%20title%3D%22Yuki_Kitazawa_3-1644462658663.png%22%20alt%3D%22%5C%26quot%3BYuki_Kitazawa_3-1644462658663.png%5C%26quot%3B%22%20%2F%3E%26lt%3B%5C%2Fspan%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ESee%20%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20docs%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Ebelow%20for%20limitations%20on%20working%20with%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20AG%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Ewith%20failover%20cluster%20manager%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E.%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3ELimitations%20for%20working%20with%20availability%20groups%20by%20using%20WSFC%20Failover%20Cluster%20Manager%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fja-jp%252Fsql%252Fdatabase-engine%252Favailability-groups%252Fwindows%252Ffailover-clustering-and-always-on-availability-groups-sql-server%253Fview%253Dsql-server-ver15%2523restrictions-on-using-the-wsfc-failover-cluster-manager-with-availability-groups%26amp%3Bdata%3D04%257C01%257CYuki.Kitazawa%2540microsoft.com%257C0ac4aa6c5fd143e2363e08d9ebf0da66%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637800242016987844%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C3000%26amp%3Bsdata%3DaBqNBPfW7F2WhtSXElkjrMpozVmjeu4SfDXloAboM5Y%253D%26amp%3Breserved%3D0%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20nofollow%3D%22%22%20noreferrer%3D%22%22%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fja-jp%2Fsql%2Fdatabase-engine%2Favailability-groups%2Fwindows%2Ffailover-clustering-and-always-on-availability-groups-sql-server%3Fview%3Dsql-server-ver15%23restrictions-on-using-the-wsfc-failover-cluster-manager-with-availability-groups%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EAlways%20On%20%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3EAvailability%20Group%20Prerequisites%2C%20Limitations%2C%20and%20Recommendations%26lt%3B%5C%2FSPAN%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%5Cn%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fja-jp%252Fsql%252Fdatabase-engine%252Favailability-groups%252Fwindows%252Fprereqs-restrictions-recommendations-always-on-availability%253Fview%253Dsql-server-ver15%26amp%3Bdata%3D04%257C01%257CYuki.Kitazawa%2540microsoft.com%257C0ac4aa6c5fd143e2363e08d9ebf0da66%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637800242016987844%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C3000%26amp%3Bsdata%3DbC9iwpw2go2nM8P6KXCpp5%252FBvRlKC8LQrMaseifpep4%253D%26amp%3Breserved%3D0%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20nofollow%3D%22%22%20noreferrer%3D%22%22%3E%3CSPAN%20data-contrast%3D%22%5C%26quot%3Bauto%5C%26quot%3B%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fja-jp%2Fsql%2Fdatabase-engine%2Favailability-groups%2Fwindows%2Fprereqs-restrictions-recommendations-always-on-availability%3Fview%3Dsql-server-ver15%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FA%26gt%3B%3CSPAN%3E%26nbsp%3B%26lt%3B%5C%2FSPAN%26gt%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3146787%22%20slang%3D%22ja-JP%22%3ENotes%20when%20working%20with%20SQL%20Server%20Always%20On%20Availability%20Group%20resources%20in%20failover%20cluster%20manager%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3146787%22%20slang%3D%22ja-JP%22%3E%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EHello%2C%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20this%20is%20the%20SQL%20Server%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Esupport%20team.%20%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EThis%20article%3C%2FSPAN%3E%20introduces%20some%20things%20%3CSPAN%20data-contrast%3D%22auto%22%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20%3C%2FSPAN%3E%20to%20keep%20in%20mind%20when%20working%20with%20Failover%20Cluster%20Manager%20when%20configuring%20%3CSPAN%20data-contrast%3D%22auto%22%3E%20sql%20server%20always%20on%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eavailability%20groups%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20(%3C%2FSPAN%3EAG%3CSPAN%20data-contrast%3D%22auto%22%3E).%20%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAG%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Esynchronization%20is%20achieved%20by%20transferring%20transaction%20logs%20between%20the%20primary%20and%20secondary%20replicas%2C%20and%20the%20SQL%20Server%20instance%20manages%20synchronization%20mode%2C%20synchronization%20status%2C%20and%20so%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eon.%20%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EBecause%20%3CSPAN%20data-contrast%3D%22auto%22%3EWSFC%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Edoes%20not%20maintain%20the%20synchronization%20state%20of%20the%20AG%2C%20it%3C%2FSPAN%3E%20is%20basically%20not%20supported%20to%20work%20with%20the%20%3CSPAN%20data-contrast%3D%22auto%22%3EAG's%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20WSFC%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eresources%20from%20the%20failover%20cluster%20manager.%20%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EOperations%20such%20as%20AG%20failover%20and%20synchronization%20mode%20changes%20must%20be%3C%2FSPAN%3E%20performed%20%3CSPAN%20data-contrast%3D%22auto%22%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eon%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20SQL%20Server%20Management%20Studio%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20GUI%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Eand%20queries%20on%20SQL%20Server%20instances.%20%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3ESql%20Server%20%3C%2FSPAN%3E%20instances%20change%20settings%20and%20failover%20%3CSPAN%20data-contrast%3D%22auto%22%3E%20WSFC%20%3C%2FSPAN%3E%20resources%20%3CSPAN%20data-contrast%3D%22auto%22%3Ebased%20on%20what%3C%2FSPAN%3E%20%3CSPAN%20data-contrast%3D%22auto%22%3Ethey%20have%20interacted%20with.%20%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAs%20an%20example%2C%3C%2FSPAN%3E%20%3CSPAN%20data-contrast%3D%22auto%22%3Ethe%20%22executable%20owner%22%20property%20of%20a%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EWSFC%20%3C%2FSPAN%3E%20resource%20is%20%3CSPAN%20data-contrast%3D%22auto%22%3Econfigured%20to%20be%20checked%20if%20the%20AG%20replica%20is%20set%20to%20auto-fail%20over%2C%20and%20not%20if%20it%20is%20not%20auto%20failover%20(manual%20failover).%20%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3ETherefore%2C%20it%20is%20not%20expected%20to%20change%20the%20settings%20directly%20from%20the%20failover%20cluster%20manager%2C%20and%20if%20you%20do%2C%20unexpected%20movements%20may%20occur.%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAlso%2C%20because%20the%20cluster%20validation%20report%3C%2FSPAN%3E%20%3CSPAN%20data-contrast%3D%22auto%22%3Edoes%20not%20take%20into%20account%20the%20synchronization%20settings%20of%20the%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20AG%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22none%22%3E%2C%3C%2FSPAN%3E%20%3CSPAN%20data-contrast%3D%22auto%22%3Eit%20is%20assumed%20that%20the%20following%20warning%20will%20be%20recorded%20in%20case%20of%20a%20configuration%20that%20does%20not%20auto%20fail%20over%2C%20but%20you%20do%20not%20need%20to%20check%20the%20executable%20owner%20by%20manipulating%20the%20failover%20cluster%20manager.%20%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%E2%96%A0%20Warning%20example%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CI%3E%3CSPAN%20data-contrast%3D%22auto%22%3EThis%20resource%20contains%20missing%20nodes%20in%20the%20cluster%20listed%20as%20executable%20owners.%20Clustered%20roles%20with%20which%20this%20resource%20is%20a%20member%20cannot%20start%20on%20nodes%20that%20are%20not%20in%20the%20list%20of%20possible%20owners.%3C%2FSPAN%3E%3C%2FI%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yuki_Kitazawa_4-1644462742045.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346916iFDDA718C30819006%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yuki_Kitazawa_4-1644462742045.png%22%20alt%3D%22Yuki_Kitazawa_4-1644462742045.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%E2%96%A0%20Screen%20example%20during%20manual%20failover%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAvailability%20group%20properties%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%20%3CSPAN%3E%20(Manual%20failover)%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yuki_Kitazawa_0-1644462658660.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346912iE8DE06664ACE14E2%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yuki_Kitazawa_0-1644462658660.png%22%20alt%3D%22Yuki_Kitazawa_0-1644462658660.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EWSFC%3C%2FSPAN%3E%20%3CSPAN%20data-contrast%3D%22auto%22%3Eavailability%20group%20resource%20properties%3C%2FSPAN%3E%3CSPAN%3E%20(manual%20failover)%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yuki_Kitazawa_1-1644462658658.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346913i61889CC0A533C359%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yuki_Kitazawa_1-1644462658658.png%22%20alt%3D%22Yuki_Kitazawa_1-1644462658658.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%E2%96%A0%20Screen%20example%20during%20automatic%20failover%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAvailability%20group%20properties%3C%2FSPAN%3E%3CSPAN%3E%20(automatic%20failover)%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yuki_Kitazawa_2-1644462658662.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346914i4868DE64565BFAB7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yuki_Kitazawa_2-1644462658662.png%22%20alt%3D%22Yuki_Kitazawa_2-1644462658662.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EWSFC%3C%2FSPAN%3E%20%3CSPAN%20data-contrast%3D%22auto%22%3Eavailability%20group%20resource%20properties%3C%2FSPAN%3E%3CSPAN%3E%20(automatic%20failover)%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yuki_Kitazawa_3-1644462658663.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F346915i74211AF435F14FCD%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yuki_Kitazawa_3-1644462658663.png%22%20alt%3D%22Yuki_Kitazawa_3-1644462658663.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ESee%20%3CSPAN%20data-contrast%3D%22auto%22%3E%20docs%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ebelow%20for%20limitations%20on%20working%20with%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20AG%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ewith%20failover%20cluster%20manager%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3E.%20%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3ELimitations%20for%20working%20with%20availability%20groups%20by%20using%20WSFC%20Failover%20Cluster%20Manager%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fja-jp%252Fsql%252Fdatabase-engine%252Favailability-groups%252Fwindows%252Ffailover-clustering-and-always-on-availability-groups-sql-server%253Fview%253Dsql-server-ver15%2523restrictions-on-using-the-wsfc-failover-cluster-manager-with-availability-groups%26amp%3Bdata%3D04%257C01%257CYuki.Kitazawa%2540microsoft.com%257C0ac4aa6c5fd143e2363e08d9ebf0da66%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637800242016987844%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C3000%26amp%3Bsdata%3DaBqNBPfW7F2WhtSXElkjrMpozVmjeu4SfDXloAboM5Y%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fja-jp%2Fsql%2Fdatabase-engine%2Favailability-groups%2Fwindows%2Ffailover-clustering-and-always-on-availability-groups-sql-server%3Fview%3Dsql-server-ver15%23restrictions-on-using-the-wsfc-failover-cluster-manager-with-availability-groups%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAlways%20On%20%3C%2FSPAN%3E%3CSPAN%20data-contrast%3D%22auto%22%3EAvailability%20Group%20Prerequisites%2C%20Limitations%2C%20and%20Recommendations%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fja-jp%252Fsql%252Fdatabase-engine%252Favailability-groups%252Fwindows%252Fprereqs-restrictions-recommendations-always-on-availability%253Fview%253Dsql-server-ver15%26amp%3Bdata%3D04%257C01%257CYuki.Kitazawa%2540microsoft.com%257C0ac4aa6c5fd143e2363e08d9ebf0da66%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637800242016987844%257CUnknown%257CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%253D%257C3000%26amp%3Bsdata%3DbC9iwpw2go2nM8P6KXCpp5%252FBvRlKC8LQrMaseifpep4%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%3CSPAN%20data-contrast%3D%22auto%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fja-jp%2Fsql%2Fdatabase-engine%2Favailability-groups%2Fwindows%2Fprereqs-restrictions-recommendations-always-on-availability%3Fview%3Dsql-server-ver15%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Co-Authors
Version history
Last update:
‎Feb 09 2022 07:16 PM
Updated by: