How to Create a new SQL Server database?

Few Steps to Follow for Creating a New SQL Database

 

STEP 1

image Go to Microsoft SQL Server Management Studio > Right Click on Database > Select New Database.

 

image
STEP 2

image A new window will be open. Enter name of the database in Database name field.

image In Owner field you can add those name of user which are authorized to access this database. Otherwise you can remain it as Default.

image You can set Initial Size and Autogrowth of the database manually.

image Now click on OK.

 

image
STEP 3

Now explore Database folder, you will see a new Database has been created.

 

image
STEP 4
  • In installation folder of the SQL Server you will get two files will be created of that database name. One is MDF file which is the primary file of the database and another will be LDF file which is the log file of the database which contains transactions deatils of the database.

 

Home SysTools FAQs » SQL Server » How to Create MDF File
Loading