Getting "The primary file must be at least 1024 MB to accommodate a copy of the model database" while trying to create the SMP database
Article ID: 161520
Updated On:
Products
Issue/Introduction
The customer is trying to install ITMS on a new server. While the configuration process is running during the initial installation, a failure occurred while trying to create the new Symantec_CMDB database.
This is the error that is displayed in the NS logs: "The primary file must be at least 1024 MB to accommodate a copy of the model database"
Cause
The model database defaults vary depending on the version of SQL Server. For example, with SQL Server 2016, SQL Server 2017 and SQL Server 2019 the default initial size of both the model database Primary data (model.mdf) and Log file (modellog.ldf) is 8 MB. The Primary data file is set to Autogrow by 64 MB until the disk is full. The Log file is set to Autogrow by 64 MB to a maximum of 2 TB.
If the file sizes of the model database are too large, there may not be sufficient disk space to create the initial custom database.
Our code, under DBConfiguration.cs, we specify a database size creation of 1000 MB. The new databases will start out no smaller than the Model database. When we create a new database, SQL server uses Model DB as a template. SQL server doesn't like to create a database that is smaller than their Model DB. Since the customer have it set to 1024 MB (no the default value) and we were trying to create a 1000 MB database, then SQL server displayed the mentioned error.
Resolution
In this particular instance, change the Model database size from 1024 MB (or whatever higher value that you may be using) to 3 MB. Restart the installation process via SIM and it should finish creating the Symantec_CMDB database successfully.
1. Open Microsoft SQL Server Management Studio
2. Under Databases> System Databases, right-click on Model and open Properties.
3. Under 'Files', change the 'Initial Size (MB)' to 3 for example. Click OK.
Applies To
ITMS 7.5 SP1 However, this could also occur on previous or later versions.
Feedback
