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

I have recently encountered an issue with a third-party Β backup application (Commvault) . I was trying to backup the databases on 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.]”

For some Application, we need to ensure we have both 32 bit and the 64-bit version of assembly found under c:\Windows\assembly. This Assembly Version=10.0.0.0 is something to do backward compatibility with SQL 2008 or R2 feature pack.
I couldn’t able to list the assembly in the c:\windows\assembly folder.

Before

batchparser

Download the Microsoft SQL Server 2008 Feature Pack

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

SQL Error

After

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

Successful Backup!!!.

I hope someone may get the hint from this post.

Job was done:-)

 

 

Unknown's avatar

About Prashanth Jayaram

DB Technologist, Author, Blogger, Service Delivery Manager at CTS, Automation Expert, Technet WIKI Ninja, MVB and Powershell Geek My Profile: https://social.technet.microsoft.com/profile/prashanth jayaram/ http://www.sqlshack.com/author/prashanth/ http://codingsight.com/author/prashanthjayaram/ https://www.red-gate.com/simple-talk/author/prashanthjayaram/ http://www.sqlservercentral.com/blogs/powersql-by-prashanth-jayaram/ Connect Me: Twitter @prashantjayaram GMAIL [email protected] The articles are published in: http://www.ssas-info.com/analysis-services-articles/ http://db-pub.com/ http://www.sswug.org/sswugresearch/community/
This entry was posted in SQL and tagged . Bookmark the permalink.

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

  1. mohan's avatar mohan says:

    i want scripts to run through powershell scripting sql service stop and start

    Like

Leave a comment