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
- x64\SharedManagementObjects.msi
- x64\SQLSysClrTypes.msi
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:-)