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

book

Article ID: 161520

calendar_today

Updated On:

Products

IT Management Suite

Issue/Introduction

The customer is trying to install ITMS 7.5 SP1 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

This message is generated by the SQL Server engine. For Microsoft SQL 2008 R2 and SQL 2012 a primary file needs a minimum capacity of 3 MB to receive a copy of the Model database and create a SQL Server database successfully for the SMP. 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. Click OK.

 


Applies To

ITMS 7.5 SP1 However, this could also occur on previous or later versions.

Attachments