Error while restoring the Store Backup file at Store
Problem–
While trying to take a Store Backup from HO (Enterprise Server) OR While restoring a Store Backup file (Store Initialization) we may come across the following error.
The Error Description will be like:
“Could not load file or assembly..Microsoft.SqlServer.ConnectionInfo,Version = 10.0.0.0”This error may come for SQL 2005, 2008, 2012 or any version
Depending upon the version we will have to run the setup for the specific SQL SMO to install it
Screenshots of Error that may come up on MC while restoring the Backup or taking Backup
Overview of SQL Server SMO - SQL Server Server SMO is a collection of objects that are designed for programming all aspects of Microsoft SQL Server.
Here is a screenshot of the same for SQL Server 2012:
Resolution –
To resolve the issue we need to run the Standard setup for installing SQL SMO Objects for the specific version. The SMO are available on Microsoft SQL Server website and can be downloaded from there.
Related Articles
Error while taking a Store Backup from HO or While restoring a Store Backup file
******** Internal******** Version: Not version specific. Issue: While trying to take a Store Backup from HO (Enterprise Server) OR While restoring a Store Backup file (Store Initialization) we may come across the following error: “Could not load file ...Error while taking a Store Backup from HO or While restoring a Store Backup file
Problem Statement: We are facing below error while taking backup from HO for new store or Restoring HO db on store to initialize error "Retrieving the COM class factory for component with CLSID {100202C1-E260-11CF-AE68-00AA004A34D5} failed due to the ...Error is occurring while taking backup from HO for new store or Restoring HO db on store to initialize
Problem Statement: We are facing below error while taking backup from HO for new store or Restoring HO db on store to initialize error "Retrieving the COM class factory for component with CLSID {100202C1-E260-11CF-AE68-00AA004A34D5} failed due to the ...Error message "Scripts.xml missing" when trying to restore the store backup on the new store pc
Product version: 6.5 Update 5, 6.6 Problem statement: Below error can be encountered while restoring the store backup on the store machine. This has been found appearing at a time while re-initializing the store Below is the screenshot of the error: ...Problem In Store Database Backup Restore.
Problem : Unable to Create Store Database from HO Management console. Script.xml is not created in the backup file. Reason : Earlier backups were corrupts because following SQL statement was throwing error as: Select A.* From InvSerial A ...