In this video you will learn how to create database using SQL Server Management Studio as well as using T-SQL script. You will learn some of the best practices of creating SQL Server Databases and learn some of the important database options to consider while creating SQL Server Databases.
Scripts used in this video
USE [master]
GO
/****** Object: Database [SalesOrders] ******/
CREATE DATABASE [SalesOrders]
CONTAINMENT = NONE
ON PRIMARY ( NAME = N'SalesOrders',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLPROD\MSSQL\DATA\SalesOrders.mdf' ,
SIZE = 2048KB , MAXSIZE =UNLIMITED, FILEGROWTH = 1024KB )
LOG ON ( NAME = N'SalesOrders_log',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLPROD\MSSQL\DATA\SalesOrders.ldf' ,
SIZE = 1024KB , MAXSIZE =2048MB ,
FILEGROWTH = 10%)
GO
Scripts used in this video
USE [master]
GO
/****** Object: Database [SalesOrders] ******/
CREATE DATABASE [SalesOrders]
CONTAINMENT = NONE
ON PRIMARY ( NAME = N'SalesOrders',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLPROD\MSSQL\DATA\SalesOrders.mdf' ,
SIZE = 2048KB , MAXSIZE =UNLIMITED, FILEGROWTH = 1024KB )
LOG ON ( NAME = N'SalesOrders_log',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLPROD\MSSQL\DATA\SalesOrders.ldf' ,
SIZE = 1024KB , MAXSIZE =2048MB ,
FILEGROWTH = 10%)
GO
How to Create Database in SQL Server 2014
Hi Sir,
ReplyDeleteCreateDB_Options query is not mentioned here as you have shown in tutorial video. Can you please make it available for the same?
And your each tutorial awesome sir.