Create Database Using Enterprise Manager in SQL Server

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.

In SQL server we can create database using Enterprise Manager.

Steps for creating database using Enterprise Manager

Step 1 : Start SQL server :

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

Step 3 : Enter name of database :

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

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

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

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

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

Step 9 : Now EMP_INFO database is created: