I used to be patching our DB Servers this morning and encountered a very unusual error when failing over some Availability Teams :
In the environment, we’re working a considerably unconventional setup, nevertheless it works effectively.
We have now 85 Databases, working SQL Server Customary, so every DB has its personal Availability Group.
What we do as a default, is to truly “Load Steadiness” the supply teams between the two servers. This implies by default, we solely have about 42 databases on every node, till patching the place I failed all of the DB’s over to 1 node, and that after I obtained the error on about 24 databases.
In preliminary investigations, I discovered that you would be able to solely have 64 NetBIOS names per useful resource. Are Availability Teams not their very own useful resource?
In one other article, they discuss guaranteeing you don’t have any duplicate IPs or DNS names. I can affirm that we now have no duplicates of both.
Is it a chance, that on SQL Customary, you may solely have 64 availability teams per database?
Please assist with any potential resolutions.
Thanks very a lot to your time.