How do I change a DB Collation without removing the DB from high availability group? Can I just take it offline and change it? or I really do need to take it out of high availability group 1st then set to single user then alter then reset it back to multiuser and back to high availability? will it cause an issue with the partner database?
Sorry I forgot the specs. I accidentally choose a case sensitive collation type. and I want to change it to Case insensitive type. but this DB is on the high availability always on group.