Thursday, October 13, 2011

The CREATE DATABASE statement failed. The primary file must be at least 3 MB to accommodate a copy of the model database.

Hello Techie,
Today is another exciting day for me has issue was faced by me in SQL SERVER 2008 while attaching the database.I won't be able to attached the database and got the following error..

The CREATE DATABASE statement failed. The primary file must be at least 3 MB to accommodate a copy of the model database. 
 Figure 1

Figure 1 shows the error while attaching the database.

I searched Google for the error & got the solution from the following link.
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/90ac791a-317c-430c-b862-f0a6c1975a21/


On the server where this fails, verify the size of the Model database. It has inadvertently become larger than expected.

All newly created databases use the Model database as a 'template'. The new databases will start out no smaller than the Model database. As this message indicates, since the Model database is about 3 MB in size, you MUST have a minimum size of 3 MB.

Figure 2
 Figure 2 shows the cause of the error.Model Database Size is 3 MB so it is not allowing the create a database with lesser size than this.

Figure 3
Figure 3 shows the attributes SIZE in which the size is mentioned.This attribute is not necessary but use then must check that it should not be less in the size of the Model database. In the figure 3 I change the size as 3 MB.

Figure 4
In Figure 4, we can see the database is created successfully after specifying the size as 3 MB.

Figure5
In Figure 5, I removed the SIZE attribute and fire the query & here also database is created successfully.In Figure 5, we can see that if the SIZE attribute is not specified then their is no error.

As per the discussion mentioned on the above link I tried the things & it worked for me so giving the entire issues for future use.

No comments:

Post a Comment

We Received your subscription request.