The CREATE DATABASE statement failed. The primary file must be at least x MB to accommodate a copy of the model database

ERROR MESAGGE:

“The CREATE DATABASE statement failed. The primary file must be at least x MB to accommodate a copy of the model database.”

EXPLANATION:

In SQL Server, you receive this error when you try to create a database that has data or log files that are smaller in size than the Model database’s data or log files.

SOLUTION:

You can resolve this error by reducing the size of the data and log files of your model database.