Thursday, February 27, 2020

Configuration Backups Fail After Moving SQL Database

Veeam B&R 9.5b. I moved a SQL database from SQL Express to a dedicated SQL 2016 
I stopped all Veeam services, used SQL Management Studio to detach the database and then attached on my SQL 2016. I then ran the Database connection utility to specify the new server.

And got this error :
Could not load file or assembly 'Microsoft.SqlServer.BatchParser,
Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
or one of its dependencies. The system cannot find the file specified
I had to install these two packages, to solve the problem

x64\SharedManagementObjects.msi

x64\SQLSysClrTypes.msi
https://www.microsoft.com/en-us/download/details.aspx?id=52676

No comments:

Post a Comment

RECENT POSTS

February 1, 2022 - end-of-support of the following products

  This message is to inform you that effective   February 1, 2022 , the following products will reach end-of-support: Veeam ®   Backup &...