Sql server create database

create database student

on primary

(

   name='st_data',--àit is use for logical name.

   filename='f:\mydata\st_data.mdf',--à it is used actual store data in the hardisk

   size=10mb,

   maxsize=20mb,

   filegrowth=2mb

),

(

   name='st_data1',

   filename='f:\mydata\st_data1.ndf',

   size=10mb,

   maxsize=12mb,

   filegrowth=3mb

)

log on

(

   name='st_data2',

   filename='f:\mydata\st_data2.ldf',

   size=12mb,

   maxsize=20mb,

   filegrowth=4mb

)

The create database process is allocating 10.00 MB on disk st_data for .mdf file.10 MB on disk st_data1 for .NDF file

And 12 mb on disk st_data2 for .LDF file .

• We can see this result

• After running this query . we can see this result

•  Go to database properties and select files .

• We can see this result 

  Step-1

  

  
  

  Step-2