On-Premises Script Error - "The Primary File...model database"

The issue:

Error message: "The primary file must be at least X MB to accommodate a copy of the model database" (1024 in this example, it depends on the environment setup)

 

 

The Reason:

When DB is created it uses the Model DB as template, the model DB is a built in system database in SQL.

In our ControlUp On-Premises data base creation script, we use:

DECLARE @dbDataFileSize VARCHAR(10) = 50

 2017-02-23_1417.png

 

The Resolution:

Please right click the Model DB and go to properties -> Files and check the initial size (MB)

 Model-DB-SS.JPG

Then edit the SQL script the On-Premises wizard created, Line 30, edit the value and change it from 50, in this example as you see the Initial size is 128MB, so in the script change it to 129MB, and that will resolve the issue.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk