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% )