CREATE DATABASE Bookshop
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',
filegrowth=10%
)
log on
(name='testdb_log',
filename='E:\Databases\testdb_log.ldf',