#Lync Question 44: What SQL collation should I use

I have been asked this question quite a few time now.

As much as I believe (according to a few SQL administrations) it is best practice to match the server collation with the database collation for performance reasons for Lync you really don’t want to this.

The server collation should be Latin1_General_CI_AS

If you interested all the Lync Server 2013 databases use Latin1_General_BIN collation, this is a case sensitivity collation and if you happen to match the collation then you will probably run into issues with mirroring the archiving and monitoring databases as they their database naming is mixed case.

Advertisements

2 thoughts on “#Lync Question 44: What SQL collation should I use

    • Latin_General_BIN is case sensitive collation and I know from experience that the mirroring scripts (which are used for DB mirroring) all reference the databases in lowercase within the code however the monitoring databases are mixed case name thus I ran into issue with mirroring them. I’m not sure if this has changed in the later CU but the only workaround was to install SQL server with a non case sensitive collation.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s