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.

NEW WAY TO INSTALLING OPERATING SYSTEM-USB BOOT

Hello Techie,
Many Days I was facing problems while installing operating systems on non-optical drive machine.I tried many things to install required operating system on a particular system but not able to install.Then finally I decided to boot the machine from the most popular method nowadays i.e. USB BOOT.

Part 1:

But the one tool I know which is Hiren Boot CD.This tool is use to repair the harddisk of a particular system.It has many options which can be use as per the requirement of the user.One can also experiments various tasks using this utility.

Following are the links to get this utility and working tutorial:
1.Hiren's BootCD From (USB Pen Drive)
2.Hiren’s BootCD 14.1
After downloading this utility anybody can use the features of these utility as per requirement.
--------------------------------------------------------------------------------------------------------------
Part 2:

Now the first thing is completed.Next comes the actual Operating System Boot from the USB on the particular system.For this another utility is require which i tried a few days back and it worked fine for me to install Windows 2003 Server Enterprise Edition SP2 on my system.
Following is the link to get this utility:
1.WinSetupFromUSB 1.0 Beta 7 / 0.2.3
Using this utility the require operating system setup can be transfer on the USB drive from which the system has to boot.Be sure to change the BIOS setting of the particular system to allow the USB boot.
Please give your feedback and suggestion.