How to create Database in SQL Server with TSQL

sql2008

USE master
GO
CREATE DATABASE Arm_DB 
 ON 
   (
     NAME = Arm_DB_Dat
     ,FILENAME = 'C:\Arman\Mine\MyBlog\Database\Arm_DB_Dat.MDF'
     ,SIZE = 20
     ,MAXSIZE = 200
     ,FILEGROWTH = 8
   ) 
 LOG 
  ON 
    (
     NAME = Arm_DB_Log
     ,FILENAME = 'C:\Arman\Mine\MyBlog\Database\Arm_DB_Log.LDF'
     ,SIZE = 15MB
     ,MAXSIZE = 125MB
     ,FILEGROWTH = 5MB   
    )

GO
Advertisement

One thought on “How to create Database in SQL Server with TSQL”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s