cancel
Showing results for 
Search instead for 
Did you mean: 

Enterprise Vault and SQL Server Compatibility Levels

Rob_Wilcox1
Level 6
Partner

 

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."
 
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."