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

  • Updated on Feb 6, 2026
  • 2 minute(s) read
  • VN
 Prev Next

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

Summary

When creating a new database, or upgrading the SecureDoc database, you may get the following error.

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 100 MB to accommodate a copy of the model database.

 

Cause

This error occurs because the SecureDoc Enterprise Server is attempting to create a database that is smaller than the Model database of the SQL Server.

When an application creates a new database, the SQL Server copies the Model database into the new database that has been created.   If the application creates a database that is smaller than the Model database, it will prevent the creation of the database.

In a fresh installation of  the Microsoft SQL Server the default size of the Model database is 2 MB. This meets the requirements for when the SES database is created. The error above only occurs when this file has been set to a size value greater than 50 MB, and WinMagic has only encountered problems in customer sites where the customer has altered the base size of the Model database for their own reasons. 

 Solution

To allow the creation of the SES database, the size of the Model database must be reduced in size.     The size can be set under 50 MB to allow the creation of the SES Database.

To re-size the Model database, you will need the Microsoft SQL Server Management Studio application.   

The Model database can be found under Databases --> System Databases

Go into the properties of the database

In the properties, of the database, go to Files.  

In the file list, enter a number smaller than 50 MB in Initial Size of the PRIMARY file group.

Click OK. 

Once the size has been reduced, you can continue with the database creation of the SES database.

 

The size of the Model database can be changed back to its original size when the SES database creation has been completed

IMPORTANT:  Those customers that have altered the size of the Model database from its default size should be cautioned that they will need to reduce the size of the Model Database whenever either
a) Installing SES (which will copy the Model database into the new SES database) or
b) Upgrading SES (since the upgrade process creates a short-lived intermediate database used to migrate data into the upgraded-format SES Database).

Custom Fields

  • Operating System: Windows Server
  • Version: Affects all versions of SD