SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Fix Commvault Backup Failures After an Upgrade

By Ganapathi varma Chekuri,

One of my friend sent an email that backups of a SQL Server 2016 instance are failing suddenly when the backups run through the Commvault backup tool. The error is:

Error Code: [30:325]
Description: Error encountered during backup. Error: [System.IO.FileNotFoundException:Could not load file or assembly 'Microsoft.SqlServer.BatchParserClient, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. Could not load file or assembly 'Microsoft.SqlServer.BatchParserClient, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.]

In below screenshot, backups status fails with error code [30:325] in Commvault console.

Cause

When logged into SQL Server machine and investigated the logs to identify if any recent changes on SQL instance. In C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\summary.txt shows that SQL Server 2008 R2 was upgraded the previous night to SQL Server 2016. Then the backup starts failing. You can also find installed date in add/remove program features in control panel.

In below screenshot, Control planeàPrograms and Features showing installed date

Resolution

For a successful backup or restore of the SQL server that has Microsoft SQL Server 2016 or its components installed, complete the following high-level steps.

Note: Follow these steps only if you are working on Commvault V10 SP14 or V11 SP5 and earlier.

From the Windows Registry Editor, create a new registry key using the following details:

  • Name: SqlFactoryUse40
  • Subkey: HKEY_LOCAL_MACHINE\SOFTWARE\CommVault Systems\Galaxy\Instance###\MSSQLAgent
  • Type: DWORD
  • Value: 1

In below screenshot, Add new registery key as SqlFactoryUse40.

At the ContentStore Base directory, create a config file named SQLBackup.exe.config, and add the following XML content to this file:

  <?xml version="1.0" encoding="utf-8" ?>
  <configuration>
  <startup useLegacyV2RuntimeActivationPolicy="true">
  <supportedRuntime version="v4.0" />
  </startup>
  <runtime>
  <NetFx40_LegacySecurityPolicy enabled="true"/>
  </runtime>
  </configuration>

 In below screenshot, I have created the SQLBackup.exe.config file.

To manually register a new DLL to V4 .NET Framework, at the command prompt, go to the %SystemRoot%\Microsoft.Net\Framework64\v4.0.30319 directory, and type one of the following commands.

For V11:

RegAsm.exe "<<CommVault\ContentStore\Base>>\CvSQLSmoV4Factory.dll"

For V10:

RegAsm.exe "<<Program Files\Commvault\Simpana\Base>>\CvSQLSmoV4Factory.dll"

Restart Commvault services on the client. In below screenshot, I have registered the .dll manually.

Now run the backup job in the Commvault tool. It runs successfully. In below screenshot, Commvault console shows backup status

For more information: http://kb.commvault.com/article/SQL0019

Ganapathi varma Chekuri

Lead SQL DBA, MCP

Email: gana20m@gmail.com

Linkedin

 
Total article views: 482 | Views in the last 30 days: 1
 
Related Articles
BLOG

Fix SQL Server Commvault Backup Failures After an Upgrade

One of my friend sent an email that backups of a SQL Server 2016 instance are failing suddenly w...

FORUM

Commvault thinks log chain broken, launches full backup during business day

Not the first time this has happened. Sql Server shows log backups running fine, via commvault. Bu...

FORUM

Who uses the Commvault IdataAgent for sql backups?

I know this has been discussed but we're on the verge of using Commvault for sql backups. I'm not h...

FORUM

Conflict between Commvault and SQL Server Backup

I have a strange sittuation here, On one of the live server(2008 R2+SP2) we have Commvault as well a...

FORUM

Commvault backup tool creates proprietary backup files

This is really a more overall admin question since I'm interested in views about the whole backup/re...

Tags
 
Contribute