ON?
PRIMARY?--创建主数据库文bai件?
(?
NAME=‘Bookshop_data‘,?
FILENAME=‘E:\Databases\Bookshop?_data.mdf‘,?--路径自du己更改zhi
SIZE=5MB,?
MaxSize=10MB,?
FileGrowth?=?10%?
)?
LOG?ON?--创建日志文dao件?
(?
NAME=‘Bookshop?_log‘,?
FileName=‘E:\Databases\Bookshop?_log.ldf‘,?--路径自己更改
Size=5MB,?
FileGrowth=2MB?
)?
GO
create database testdb
on
primary
(name=‘testdb_data‘,
filename=‘E:\Databases\testdb_data.mdf‘,
SIZE=5MB,?
filegrowth=10%
)
log on
(name=‘testdb_log‘,
filename=‘E:\Databases\testdb_log.ldf‘,
SIZE=5MB,?
filegrowth=10%
)