How to Create a new SQL Server database?

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

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

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

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

Now click on OK.

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

• 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.