How to create a SQL Database on SQL Server 2014

TECHIE >> Software
6/28/2015 8:28:32 PM

 

 

 

1) Click on the Start button

Image

2) Locate SSMS (SQL Server Management Studio) under Apps

Image

3)Open SSMS

4) Expand the Database Instance

Image

5) Select Database. Right Click and choose "New Database."

Image

6) Provide a Database Name. Specify the Data and Log Files. For performance, keep the data and the log files on separate drives. Specify Database owner if you have a windows authentication or SQL specific account to that database.

Image

Select the options TAB and specify additional options if needed, such as FILESTREAM. In this demonstration, we'll keep the default Settings.

Image

7) Choose "Ok."

8) You will now be able to see your database created. In this example, I created the LeagueOfLegends database.

Image

                                You can also create a SQL database through a SQL Create statement

1) Right click on the SQL Instance and choose "New Query"

Image

2) Type in the following command CREATE DATABASE WarCraft;  Click Execute or F5       

Image

3) Review the Message below to verify creation was successful.

Image

4) You can also verify if the database was created successfully by expanding the SQL Instance, Expand Databases.

Image

5) From here, you can right click on the database and choose properties to modify settings.


 


Comments (0)

Page Views: 1303 Users: 2 IPs: 700

Post a comment
Name:  
Email: (optional)
Comments: