SQL Server 创建数据库

最新推荐文章于 2020-08-22 08:45:58 发布

原创最新推荐文章于 2020-08-22 08:45:58 发布 · 341 阅读

0 ·

CC 4.0 BY-SA版权

数据库专栏收录该内容

14 篇文章

订阅专栏

本文详细介绍了一个SQL Server数据库创建脚本，用于构建名为Northwind的数据库。该数据库包含多个数据文件和日志文件，分布在不同的文件组中，如主文件组和次文件组G1、G2，每个文件组包含多个数据文件，所有文件均存放在D盘的Northwind目录下，此外还配置了日志文件及其增长策略。

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