After a database migration to different server, the following error message is displayed in logs
Cannot resolve collation conflict between Latin1_General_Cl_AS and SQL_Latin1_General_CP1_Cl_AS in CASE operator occurring in SELECT statement column
Also, the Coordinator logs can show the following
VSTS129235
When a Collation mismatch is identified, the Coordinator will try to fix which will use and increase the size of the Transaction log
This process will take from several hours to several days based on the Database size and will potentially double the size of both MDF and LDF files
If the available space is not sufficient, the process might fail and result in a Database stuck with the wrong Collation
This can lead to issues linked to database connection
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center