• Facebook
  • RSS Feed
  • Instagram
  • LinkedIn
  • Twitter
Feb 282013
 

A question that is raised from time to time on the Symantec Connect forums relates to SQL Compatibility Levels and whether or not they are important. SQL Compatibility is described by Microsoft as:

“Compatibility level provides only partial backward compatibility with earlier versions of SQL Server.”
— Reference: http://msdn.microsoft.com/en-us/library/bb510680.aspx

You can see the current SQL Compatibility Level by executing:

select name, compatibility_level from sys.databases

In the end you want this to match your SQL Server version, running at an older version can have undesirable effects on Enterprise Vault. The Enterprise Vault Compatibility Charts state:

“Note: Enterprise Vault supports SQL databases only at their default compatibility levels.”

— Reference: http://www.symantec.com/docs/TECH38537

Aug 092012
 

As many people know I’m not a particularly brilliant or shining star when it comes to SQL.  One thing that I do know though is that it is important to ensure with Enterprise Vault that you have certified/supported service packs.  A few days ago I stumbled across this blog posting:

http://sqlserverbuilds.blogspot.co.uk

You can see build numbers like this:

A handy reference when used in conjunction with the Compatibility Guide.