Install-CsDatabase Error (The CREATE DATABASE statement failed. The primary file must be at least %MB to accommodate a copy of the model database.)
Over the time the Model Database was increased to some new values.
It is necessary adjusting the Model Database in SQL back to 2MB, which is requried for initiating a new Database with the Lync integrated script.
Therefor you need to login to SQL Server and navigate to the System Databases and right cklick the MODEL DB and SHRINK it back (Database and File) to 2MB
The model database is an empty hull for each new database that should be created. If the size is not matching, you run into this common error.
In Lync deployment log, you will find the following error:
Feature: CentralMgmtStore 11.04.2013 10:18:10
└ SQL Instance: sql01.customer.com 11.04.2013 10:18:10
└ Collocated: False 11.04.2013 10:18:10
└ Found "RTCUniversalServerAdmins": True 11.04.2013 10:18:10
└ Found "RTCUniversalConfigReplicator": True 11.04.2013 10:18:10
└ Found "RTCUniversalReadOnlyAdmins": True 11.04.2013 10:18:10
└ InstallDatabaseInternalFailure: An internal error has occurred while trying to create or update the database. 11.04.2013 10:18:10 Error
Error: The CREATE DATABASE statement failed. The primary file must be at least 50 MB to accommodate a copy of the model database.
└ Type: SqlException
└ ► Stack Trace
The Technet Link supporting the task can be found here:
Author: Thomas Poett Business Unit Leader Skype for Business