SQL Server 创建数据库

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

petezh

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

阅读量293

点赞数

分类专栏：数据库

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

版权

数据库专栏收录该内容

14 篇文章 2 订阅

订阅专栏

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