Database MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Database
  4. Creates a database with explicit specifications for database and transaction log files
6>  CREATE DATABASE projects
7>       ON (NAME=projects_dat,
8>         FILENAME = 'C:\DATA\projects.mdf',
9>         SIZE = 10,
10>         MAXSIZE = 100,
11>         FILEGROWTH = 5)
12>       LOG ON
13>       (NAME=projects_log,
14>         FILENAME = 'C:\DATA\projects.ldf',
15>         SIZE = 40,
16>         MAXSIZE = 100,
17>         FILEGROWTH = 10)
18>
19> drop database projects;
20> GO