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

May 222012
 

One of my environments consists of three Enterprise Vault servers.  Two in one site, and one in another.  I just upgraded them all, and sat waiting a while …and a while longer … and even longer.

On review of the event log, I found this:

Log Name:      Symantec Enterprise Vault
Source:        Enterprise Vault
Date:          09/05/2012 11:35:43
Event ID:      8570
Task Category: Directory Service
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      ev1a.EV.Local
Description:
The Directory Service is waiting for another Directory Service to complete an update of the EnterpriseVaultDirectory database, or waiting to get exclusive access to the EnterpriseVaultDirectory database. Please ensure no applications, for example SQL Enterprise Manager or SQL Query Analyzer, are accessing the EnterpriseVaultDirectory database.

The EnterpriseVaultDirectory database is in multi user access mode.

The current EnterpriseVaultDirectory database connections are:

Computer Name : EVAULT1
Program Name :
Login Name : EV\vaultadmin
Connections : 1

Computer Name : EVAULT1
Program Name : Microsoft SQL Server Management Studio
Login Name : EV\vaultadmin
Connections : 1

Computer Name : EVAULT1
Program Name : Microsoft SQL Server Management Studio – Query
Login Name : EV\vaultadmin
Connections : 5

For more information, see Help and Support Center at http://evevent.symantec.com/rosetta/showevent.asp?EvtID=8570

That was nice and helpful – I had in fact got SQL Management Studio open on my SQL Virtual Machine with a bunch of open sessions.

Closed them all, and I am all sorted. Something to watch out for!