1425 Error message (Primary file must be at least x MB to accommodate a copy of the model database) appears when attempting to create the SES database

Prev Next

Symptom:
The  error message "Primary file must be at least MB to accommodate a copy of the model database" appears when attempting to create the SES database.

The full error message is shown here:
01000-5701: [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'master'. 
37000-1803:[Microsoft][ODBC SQL Server Driver][SQL Server]The CREATE DATABASE statement failed. The primary file must be at least x MB to accommodate a copy of the model database.

Cause:
The model database of SQL Server is larger than the size of the database that SES is trying to create. 

Resolution:
The SES creates a 50 MB database. To resolve this problem, you must reduce the size of the model database to 50 MB or less.

Custom Fields

  • Error message or code: Primary file must be at least x MB to accommodate a copy of the model database

  • Operating System: Windows Server

  • Version: Affects all versions of SD