SQL CREATE DATABASE error: the primary file must be at least 100 mb to accommodate
Posted on 2013-12-06
In SQL 2008 R2, we get the following error upon trying to create a database:
The following SQL statement produced an error:
create database [TGOOD] ON (NAME = 'GPSTGOODDat.mdf', FILENAME = 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\GPSTGOODDat.mdf', SIZE = 50, FILEGROWTH = 20% ) LOG ON
ERROR [Microsoft][SQL Server Native Client 10.0][SQL Server]The CREATE DATABASE statement failed. The primary file must be at least 100 MB to accommodate a copy of the model database.
Is the remedy for this to shrink the model database? If so, how?
Are there any issues with shrinking the model database? If so, what remedy can be applied?