1) Click on the Start button
 2) Locate SSMS (SQL Server Management Studio) under Apps
 3)Open SSMS
4) Expand the Database Instance
 5) Select Database. Right Click and choose "New
Database."
 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.
 Select the options TAB and specify additional options if
needed, such as FILESTREAM. In this demonstration, we'll keep the default
Settings.
 7) Choose "Ok."
8) You will now be able to see your database created. In
this example, I created the LeagueOfLegends database.
 You
can also create a SQL database through a SQL Create statement
1) Right click on the SQL Instance and choose "New
Query"
 2) Type in the following command
CREATE DATABASE WarCraft; Click Execute
or F5
 3) Review the Message below to verify creation was successful.
 4) You can also verify if the database was created
successfully by expanding the SQL Instance, Expand Databases.
 5) From here, you can right click on the database and choose
properties to modify settings.
|