How to create new database in Sql 2008?

Create a Schema First , Allocate the Memory Set the Database Server and Application Server and the Logical Server.Work out on which Replication you are working, Is it a Snap Shot Replication , Merge Replication or Distributed Replication. Set the File Server and Establish the Cloud for the Implementation on parsing on the Extended Mark Up Language.

1. Open Microsoft SQL Management Studio
2. Connect to the database engine using database administrator credentials
3. Expand the server node
4. Right click Databases and select New Database
5. Enter a database name and click OK to create the database

CREATE database  databasename  and execute

1. Open Microsoft SQL Management Studio.
2. Expand the Microsoft SQL Server node where you want to create the database.
3. Right click the Databases node and then click New Database.
4. Type the database name in the dialog box, for example, MailSecurityReports, and then click OK.

using statement : CREATE DATABASE DBName

or

right click on Databases folder that exists on left pane then select create database...