Tuesday, 8 September 2015

How to create a database in Management studio ?

STEP 1 : 

Right click the database and select New Database option to create a new database in management studio.Refer the screenshot below.



STEP 2 : 

In the New database window ,enter the database name in text-box.I have created a database name as Sample.You can see the logical name created in the name of database such as sample and sample_log.Refer the screenshot below.


Here Logical name Sample is MasterDataFile and Sample_Log is LogDataFile.
The logical name can be changed by the user.
The default path is C drive(i.e Sql server installed path) highlighted in above screenshot.

STEP 3 : 

The default path can be changed to store the master data file and Log data file.Refer the screenshot below.


Here I have changed my file path to E drive.(Highlighted in Red colour)

STEP 4 : 

Now You can see the data files created at the mentioned path in the step 3.



STEP 5 : 

Finally you can see the Sample database created in the below screenshot.





No comments:

Post a Comment