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:-)

 

 

Advertisements

About Prashanth Jayaram

I’m a Database technologist having 11+ years of rich, hands-on experience on Database technologies. I am Microsoft Certified Professional and backed with a Degree in Master of Computer Application. My expertise lies in T-SQL programming, Replication and PowerShell You can connect me via https://social.technet.microsoft.com/profile/prashanth jayaram/ http://www.sqlshack.com/author/prashanth/ https://www.tumblr.com/blog/prashantjayaram http://www.sqlservercentral.com/blogs/powersql-by-prashanth-jayaram/ http://www.toadworld.com/members/prashanthjayaram/ My Articles are published in following sites 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 says:

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s