SQL语句创建数据库及日志文件

create database S_T
on primary
(
name = 'S_T',
filename = 'D:\DATABASE\S_T.MDF',
size = 4MB,
maxsize = 16MB,
filegrowth = 1MB
)

log on
(
name = 'S_T.ldf',
filename = 'd:\database\S_T_log.ldf',
size = 2mb,
maxsize = 6mb,
filegrowth = 1mb
)

 磁盘效果: