Install-CsDatabase Error (The CREATE DATABASE statement failed. The primary file must be at least %MB to accommodate a copy of the model database.)

-
If you are installing the Central Management Database (XDS) for a new Skype for Business/ Lync Deplyoment, you might run into an issue if the the SQL Server was installed much earlier than Lync will be.

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.
▼ Details
 

└ Type: SqlException
└ ► Stack Trace
 

 The Technet Link supporting the task can be found here:
https://technet.microsoft.com/en-us/library/ms189080(v=sql.105).aspx

Comments

  1. AnonymousMay 28, 2013 at 5:56 PM

    This doesn't work.
    I've reset as far as model will allow me to set it. (currenty 300MB)
    The error now is "...must be at least 200MB..."
    Something just isn't right here

    ReplyDelete
  2. Thomas PoettJune 3, 2013 at 8:55 AM

    Hi,
    the Model DB can be set to any size 2MB and higher.
    Did you choose the System DB instead. Please check again let let me know
    Thomas

    ReplyDelete

Post a Comment

Popular posts from this blog

How to hide users from GAL if they are AD Connect synchronized

-
Image
How to hide and un-hide users from Global Address List (GAL) in Exchange Online if they are AD Connect synchronized Hiding User from GAL isn't possible if those are synchronized form On-Premises Active Directory. The local AD is the leading system for all important attributes, like SMTP, UPN and hiding from GAL. Especially during a cross-tenant migration, you do not want to see not migrated user in the GAL. Those User aren't actively working until their cut-over day. Since the Exchange Online attribute  msExchHideFromAddressList s is an AD on-premises parameter, we have two possible ways hiding user in BME from GAL.   Modify the AD Connect for your teant with a custom rule, by using a extensionAttribute to set the HidefromGAL. In this rule, for users which have an entry in the extensionAttribute, hiding / un-hiding will be controlled by AD Connect This is the best option for Cross-Tenant Migration, if you run 2 or more AD Connect system We direct modif...
Read more

Cannot join external Lync Meeting: Lync Edge Server Single IP Address (Lync Edge Server Single IP Web Conferenceing Problem)

-
Image
Lync Edge Server FQDN and IP PORTS (Version 1.2, Update 26.11.2014) As we all know, we can configure Lync Edge Server in several way. 1) Single Edge Server with a SINGLE IP ADDRESS 2) Single Edge Server with MULTIPLE IP ADDRESSES (3x IPs) 3) Multiple Edge Server in a Pool, with MULTIPLE IP ADDRESSES (Zx 3 IPs) Regardless what we are going to configure, there are common / well-known TCP Port necessary making Lync work, which are: Access: Port: 443 and 5061 Conferencing: Port: 443 and (444) AV: Port: 443 (I have not listed other ports, e.g. STUN or the dynamic port range. This is not required for the topic discussed here) External FQDN with single IP address: What can we see here? If we are going to choose a single IP address, we would have TCP Port overlapping. Therefore the only way avoiding this is assigning other ports. Additionally we will also see and are reminded that Lync highly depends on DNS. If we have single IP, we must have use single, uniqu...
Read more

MFA with Guest Access and different tenants settings

-
Image
There is an update regarding MFA Multi Factor Authentication. If you are guest with a different Tenant, the MFA Settings are now reflecting the settings of all tenants in a different way. Each MFA setting is reflected and you can setup your MFA device as per tenant and the admin settings allow. Login to your Profile in Office 365/ Azure AD: https://account.activedirectory.windowsazure.com/r/#/profile or https://myapps.microsoft.com Go to your PROFILE: Sign in to https://myapps.microsoft.com Select your account name in the top right, then select profile. Select Additional security verification. If might be happen, your admin hast configured MFA, so you wouldn't see this menu. Simply switch the tenant to the guest tenant where you need to configure MFA. Once you go back to your profile and you will find the MFA device and other settings a usual:
Read more