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

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=, 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= 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.



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

Successful Backup!!!.

I hope someone may get the hint from this post.

Job was done:-)




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 powershellsql@gmail.com 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=

  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