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 or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.

Solution

As per Microsoft SQL Server Standardization:

The SQL Server Express version's database size limit is 10 GB.

So either upgrade the SQL Server edition from Express to Standard version or you can reduce database size to restore a database in the same express edition.

Please go through below referral link :

https://support.gfi.com/hc/en-us/articles/360012842094-Size-Limitation-Database-Size-for-Microsoft-SQL-Server-versions-from-2000-to-2016

This KB article concludes here.