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

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading



Calendar

<<  August 2010  >>
MoTuWeThFrSaSu
2627282930311
2345678
9101112131415
16171819202122
23242526272829
303112345

View posts in large calendar