How to Create Database in SQL Server 2014 - SQL Server DBA Tutorial

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


 
How to Create Database in SQL Server 2014

12 comments:

  1. Hi Sir,

    CreateDB_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.

    ReplyDelete
    Replies
    1. CreateDB_Options query is not mentioned here

      Delete
  2. CreateDB_Options query is not mentioned here

    ReplyDelete
  3. Nice article. Agree, thanks for sharing. I'm sure others will benefit from it too 789betting vip

    ReplyDelete
  4. Hello there i read your article and followed as you said and it works for me thank you for this information
    disawar app development
    satta king development
    online matka app development
    best matka app development
    https://gomatkapro.co

    ReplyDelete
  5. You did an excellent job on this post! its very helpful for all of us
    satta matka result website development
    satta king development
    online matka app development
    best matka app development
    https://gomatkapro.plus

    ReplyDelete
  6. This blog is really amazing and very productive. This content has provided me with lots of useful information
    online matka development
    satta king development
    online matka app development
    best matka app development
    https://gomatka.co

    ReplyDelete
  7. Excellent information
    Thanks you so much for this wonderful article
    you written it looks great an unique.
    gomatkaplus
    Starline games
    satta tv
    satta tv
    Satta king
    Sattamatka
    Sattaking
    https://sattaking.chat

    ReplyDelete
  8. we are proud of you
    you did great job
    we wish you best of life

    ReplyDelete
  9. very interesting, good job, and thanks for sharing such a good blog. 123bet vip

    ReplyDelete