Database import file error: Could not load schema model from package


After a backup of all sites with databases is provided to the customer, they try to import it into their environment and receive this error:

And in the log (The one you get by clicking on details in the error message) : 

Root Cause: It was found that a property was added to file: model.xml, which was preventing the complete backup import to the local SQL Server.

<Property Value="2" Name="CatalogCollation"/>


Updating SSMS to the latest version and then trying to do the import again will fix the issue.

For more details about this issue, please look into this article.

On the attachment, you'll also find the log with the error message.

Content Author: Hamid Waqas‍




Please sign in to leave a comment.