SQL Server 创建数据库_create database [northwind] on-CSDN博客

本文链接：https://blog.csdn.net/petezh/article/details/81743929

create database Northwind
on primary --主文件组
(   name=Northwind,
    filename='d:\Northwind\Northwind.mdf',--主要数据文件
    size=5,maxsize=unlimited,filegrowth=10% --默认单位 MB
),
(   name=Northwind2,
    filename='d:\Northwind\Northwind2.ndf',--次要数据文件
    size=1,maxsize=unlimited,filegrowth=5%
),
/*+++++++++++++++++++++++++++++++++++++++++++++++*/
filegroup G1 --次文件组1
(   name=NorthwindG11,
    filename='d:\Northwind\NorthwindG11.ndf',
    size=1,maxsize=5,filegrowth=2
),
(   name=NorthwindG12,
    filename='d:\Northwind\NorthwindG12.ndf',
    size=1,maxsize=5,filegrowth=2
),
/*+++++++++++++++++++++++++++++++++++++++++++++++*/
filegroup G2 --次文件组2
(   name=NorthwindG21,
    filename='d:\Northwind\NorthwindG21.ndf',
    size=1,maxsize=5,filegrowth=2
),
(   name=NorthwindG22,
    filename='d:\Northwind\NorthwindG22.ndf',
    size=1,maxsize=5,filegrowth=2
)
/*+++++++++++++++++++++++++++++++++++++++++++++++*/
log on
(   name=NorthwindLog,
    filename='d:\Northwind\Northwind.ldf',--日志文件
    size=1,maxsize=unlimited,filegrowth=2
),
(   name=NorthwindLog2,
    filename='d:\Northwind\Northwind2.ldf',
    size=1,maxsize=5,filegrowth=2
)
go