Create Database

---- To Create the Database with multiple data files and log files

Create Database [Dbname] on primary
 (Name='Logical Name',size=10MB,Filename='C:\MSSQL\DATA\XXXXXXX.mdf',Maxsize=1024MB,Filegrowth=256MB),
(Name='Logical Name',size=10MB,Filename='C:\MSSQL\DATA\XXXXXXX.ndf',Maxsize=1024MB,Filegrowth=256MB)
Log On
(Name='Logical Name',size=10MB,Filename='C:\MSSQL\LOG\XXXXXXX.Ldf',Maxsize=1024MB,Filegrowth=10%),
(Name='Logical Name',size=10MB,Filename='C:\MSSQL\LOG\XXXXXXX.Ldf',Maxsize=1024MB,Filegrowth=10%)


--- Creating Filegroup while creating the Database

CREATE DATABASE [PDBA] ON  PRIMARY
( NAME = N'PDBA', FILENAME = N'E:\MSSQL\MSSQL10.BLR\MSSQL\DATA\PDBA.mdf' , SIZE = 2048KB , FILEGROWTH = 1024KB ),
 FILEGROUP [Secondary]
( NAME = N'PDBA1', FILENAME = N'E:\MSSQL\MSSQL10.BLR\MSSQL\DATA\PDBA1.ndf' , SIZE = 2048KB , FILEGROWTH = 1024KB )
 LOG ON
( NAME = N'PDBA_log', FILENAME = N'E:\MSSQL\MSSQL10.BLR\MSSQL\DATA\PDBA_log.ldf' , SIZE = 1024KB , FILEGROWTH = 10%)