Did you try TargetServersRole in msdb ? it's right next to SQLAgentUserRole

not sure what's going on but i can't see my reply when browsing from my phone so i will post it again:

Hi Steal and Rothj

Right before rebooting secondary server on...

Hi Steal and Rothj

Right before rebooting secondary server on the primary server's AG group properties set the following:

Availability Mode: Asynchronous Commit

Failover Mode: Manual

Seeding Mode: Manual

Session Timeout: 900

after reboot check AG...

• This reply was modified 1 year, 8 months ago by  AlexSQLForums.
• This reply was modified 1 year, 8 months ago by  AlexSQLForums.

Hi Steal and Rothj

Do you have seeding mode set to Automatic in your AG group?

Does this happen every time you reboot secondary?

"However it's a common practice here to make lives harder and execute scripts packages from shared folders using command line."

1. Import those packages into SSIS catalog
2. Remove rights to share...

Extremely paranoid. We use NAS, Data Domain and tapes but some of our backups take 12-18 hours to backup 1TB db's

Can you paste the execution plan?

Syed

In this link https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/distributed-availability-groups?view=sql-server-ver15

under "Understand distributed availability groups" which diagram is your setup?

jpnorman103 what kind of replication?

Are you replicating schema changes?

ok all the same errors but there was no failover.

i'm contacting Microsoft.

They are physical servers. We eliminated/rescheduled backups, antivirus and windows updates.

thank you

Hi Sue

We checked all the NIC cards and even updated firmware none are broadcom.

We even re scheduled backup and DFS sync jobs.

Hi Sue

i did check cluster logs and event viewer there are tons of messages about cluster losing network connections:

The Cluster service is shutting down because quorum was lost. This could...

Not sure how your setup is but you can

Make sure Cluster account has access to a new file share location.

1. Create a new file share quorum
2. Validate Cluster by choosing...

You have to call Microsoft since you have SharePoint support.

They will generate new keys for you.