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 or assembly..Microsoft.SqlServer.ConnectionInfo,Version = 10.0.0.0”
Solution:
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.
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.
To resolve the issue please 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
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 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 ...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 ...Not able to re-initialize the Store from the backup file taken from the HO MC: Database size issue
Version 6.6, Not the version-specific Issue Not able to re-initialize the Store from the backup file taken from the Enterprise MC. Finding: Below is the error in the Event Viewer log of the Store server where the issue is occurring: "CREATE DATABASE ...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 ...