首页 > 代码库 > SQL语句创建数据库及日志文件

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
)

 磁盘效果:

技术分享

 

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