Blog Post

SQL Server : Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=10.0.0.0

,

I have recently experienced an issue with a third-party  backup application (Commvault) that was trying to backup the databases from the SQL 2014 . It was throwing a below error

“Description: Error encountered during backup. Error: [ Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified.]”

This Assembly Version=10.0.0.0 is something to do with SQL 2008 or R2 feature pack. I couldn’t able to list the assembly in the c:\windows\assembly folder.

To work around this problem, download and install the following files from SQL Server 2008  Feature Pack

Download the Microsoft SQL Server 2008 Feature Pack

  1. x64\SharedManagementObjects.msi
  2. x64\SQLSysClrTypes.msi

SQL Error

The SQLSysClrTypes.msi should be installed first due to its dependency on SharedManagementObjects.

Successful Backup!!!. I hope some one may get hint from this post.

Job done:-)

 

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating