Not able to re-initialize the Store from the backup file taken from the HO MC: Database size issue

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 :

This KB article concludes here.



    • Related Articles

    • Store re-intialization Step

      Product version: 6.5 Update 6 or 6.6 Problem statement: User want to re-intialize the store. Proposed solution: Suggested customer to re-initalize Store by creating Store backup file from iVend Enterprise MC screen only when replication is cleared ...

    • 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 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 ...

    • iVend Primary Key Violation issue after Re-initialize of Store

      Product Version: 6.5 Update 6 Patch 2 Problem Statement - Primary Key Violation issue after Re-initialize of Store. Proposed Solution: - We require to increase sysnextnumber for smooth function of store. Steps if any: Below are the steps we require ...

    • 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 ...