Primary file must be at least 3 MB to accommodate a copy of the model database.

by Dmitry [dimaka] Pavlov 29. January 2010 00:43

Today I have spent some time fighting with this this error:

Primary file must be at least 3 MB to accommodate a copy of the model database.

If you are getting the error above when deploying your database project in Visual Studio 2008 to a local SQL Server 2005, you might want to enlarge the size attribute. You can do SIZE parameter here in Visual Studio Solution explorer under database project node:

  • Database
    • Schema Objects
      • Database Level Objects
        • Storage
          • Files
            • DATABASENAME.sqlfile.sql

Hope the tip saves your time!

Tags:

Visual Studio | Tips | SQL Server

Comments

Calendar

<<  February 2012  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
2728291234
567891011

View posts in large calendar