How to create a new database in Microsoft SQL Server

Introduction

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.

To Install Microsoft SQL Server on windows, Please refer our previous article

                                                  http://www.admincool.com/2017/12/how-to-install-mssql-server.html

Video Tutorial

Steps

1. Open Microsoft SQL Management Studio

2. Connect MSSQL Server with your username and password

3. Expand the Microsoft SQL Server node where you want to create the database

4. Right click the Databases node and then click New Database

5. Enter a database name

6. Select your data and log folder locations. Default location will be in your C Drive

7. Click OK