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) = 502017-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.JPGThen 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.

1-on-1 Demo
Schedule now
Price Quote
Get it now
Need a Script?
Get it here
Powered by Zendesk