SQL Server – Changing Collation with a High Availability Server

collationreplicationsql server

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.

Thank you

Best Answer

I have to remove the DB from High Availability Group(Always on), change the DB to single user, change the collation then change it back to multiuser,back to the high availability group. The good thing is this database is new and it only have 5 tables otherwise it will be more complicated. I was just hoping I don't have to remove it from the group.