CreateDataBase

gistfile1.txt

CREATE DATABASE SQLtoDT1
ON
	PRIMARY (NAME=SQLtoDT1Data, 
	FILENAME='D:\SQL_BASE\MSSQL11.MSSQLSERVER\MSSQL\DATA\SQLtoDT1_data.mdf', 
	SIZE=200,
	FILEGROWTH=200 )
LOG ON (
	NAME=SQLtoDTLog1,
	FILENAME='D:\SQL_BASE\MSSQL11.MSSQLSERVER\MSSQL\DATA\SQLtoDT1_log.ldf', 
	SIZE=1, 
	MAXSIZE=4096,
	FILEGROWTH=50
	)

CREATE DATABASE SQLtoDT2
ON
	PRIMARY (NAME=SQLtoDT2Data, 
	FILENAME='D:\SQL_BASE\MSSQL11.MSSQLSERVER\MSSQL\DATA\SQLtoDT2_data.mdf', 
	SIZE=200,
	FILEGROWTH=200 )
LOG ON (
	NAME=SQLtoDTLog2,
	FILENAME='D:\SQL_BASE\MSSQL11.MSSQLSERVER\MSSQL\DATA\SQLtoDT2_log.ldf', 
	SIZE=1, 
	MAXSIZE=4096,
	FILEGROWTH=50
	)