Following error occurs when database which is attempted to be created is smaller than Model Database. It is must that all the databases are larger than Model database and 512KB.
Following code will create the error discussed in this post.
CREATE DATABASE Tests
ON
( NAME = 'Tests',
FILENAME = 'c:\tests.mdf',
SIZE = 512KB )
GO
Msg 1803, Level 16, State 1, Line 1
The CREATE DATABASE statement failed. The primary file must be at least 2 MB to accommodate a copy of the model database.
Fix/WorkAround/Solution :
Create database which is larger than Model database and 512KB. Size of the Model Database will be displayed in the error message. If database is smaller than 512 KB it will throw error which I have described here : SQL SERVER – FIX : ERROR Msg 5174 Each file size must be greater than or equal to 512 KB
Reference : Pinal Dave (http://blog.SQLAuthority.com)
Hi For me to cerate a db in sql server 2005 it gives me the following error:
CREATE DATABASE failed. Primary file must be at least 3 MB to accommodate a copy of the model database.
So, how do reduce the primary file size of model database from 3 mb to 2mb?
In Denali (SQL Server 2012), the error message appears like below
The CREATE DATABASE statement failed. The primary file must be at least 4 MB to accommodate a copy of the model database.
I believe it means the size of Model Db is now 4 mb in Denali.
Thanks
Manish