Mega Code Archive

 

Categories / MSSQL Tutorial / Database

 

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