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', SIZE=5MB,  filegrowth=10% )

log on (name='testdb_log', filename='E:\Databases\testdb_log.ldf', SIZE=5MB,  filegrowth=10% )