Post reply

SQL Server Collation

  • April 29, 2021 at 10:18 pm

    #3877584

    I have 2 node in an availability group which has been configured for the wrong collation. Now, I would like to change the server collation. No user db's are attached. So I am thinking to remove the availability group and then re install the sql server with right collation on the same server. Is that the better approach?

  • April 29, 2021 at 11:25 pm

    #3877589

    you may be able to change it while still on the AG - but if it does not then remove the AG and do the same steps.

    see https://www.mssqltips.com/sqlservertip/3519/changing-sql-server-collation-after-installation/

    option Option # 3: Setup with SQL Server parameters to Change SQL Server Collation

  • April 29, 2021 at 11:39 pm

    This was removed by the editor as SPAM

  • April 30, 2021 at 1:45 am

    #3877621

    Personally, I'd remove SQL and re-add with the desired collation.  Changing collations can be tricky, esp. on the master db.

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

  • April 30, 2021 at 6:52 am

    #3877699

    argh. clicked the report button by mistake - can some admin undo it please.

     

    changing server collation is fully documented and supported by Microsoft - although the link I gave above is not from MS we can look at their own - https://docs.microsoft.com/en-us/sql/relational-databases/collations/set-or-change-the-server-collation?view=sql-server-ver15

    this is as per both links just a straight command line execution - and as the instance is currently empty from user databases this is easier than some may think.

  • April 30, 2021 at 4:32 pm

    #3877932

    Thanks. So the command has to run from the SQL Server installer location?

  • April 30, 2021 at 9:08 pm

    #3878025

    as far as I know yes

    Command line setup is quite used for automation but this is one of the cases where doing on command line is likely to b e the only way to do it.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply