Create Database Using Enterprise Manager in SQL Server

In this article I am going to explain how to create database using enterprise manager in SQL Server.
  • 2367

Introduction

In this article I am going to explain how to create database using enterprise manager in SQL Server. We create database using CREATE statement in SQL server. To create database using SQL query.

CREATE DATABASE EMP_INFO

 

In SQL server we can create database using Enterprise Manager.

Steps for creating database using Enterprise Manager

Step 1 : Start SQL server :

Clipboard04.jpg

Step 2 : Right click on database => now click on New Database :

Clipboard02.jpg

Step 3 : Enter name of database :

Clipboard03.jpg

Step 4 : Now click on "Options ". Here you can change recovery model and compatibility level :

Clipboard041.jpg

Step 5 : Select recovery model. It is three type Full, Bulked logged and Simple :

Clipboard09.jpg

Step 6 : Select compatibility level. It is also three type SQL Server 2000, SQL Server 2005 and SQL Server 2008 :

Clipboard08.jpg

Step 7 : Now click on "Filegroups" to change other setting :

Clipboard10.jpg

Step 8 : Now Click on OK button to complete the process:

Clipboard11.jpg

Step 9 : Now EMP_INFO database is created:

Clipboard12.jpg


© 2020 DotNetHeaven. All rights reserved.