Geek Answers Handbook

Error deploying a database in VS 2008 with SQL Server 2005 size should be at least 3 MB?

I get the following error when deploying my database in VS 2008 with local SQL Server 2005. I deployed other databases, but this one does not seem to work.

Bsg.COC.Database.dbschema (0,0) Error TSD01268: .Net SqlClient Data Supplier: Msg 1803, Level 16, State 1, Line 1 The CREATE DATABASE operation failed. The main file must be at least 3 MB in order to host a copy of the model database.

I did some searches, and some suggestions were to disable the size attribute, but I could not find where to change this parameter in the IDE, only in the output SQL query. Do you know where to find the size attribute parameter?

+5
source share
1 answer

This is fixed, in the object Database \ Schema Objects \ Database Level Objects \ Storage \ Files \ DATABASENAME.sqlfile.sql, the parameter "size = ??" if you just change this to a smaller number, which it will expand just fine.

+4
source

More articles:


All Articles