创建数据库需要注意的问题

这里的name指定一定要按照要求：举个例子

name的main_1一定要和FileName里面的main_1相同

create database testdb
on primary
(
name=main_1,
fileName='c:/main_1.mdf',
size=100MB,
MaxSize=200MB,
Filegrowth=20MB),
(
name=main_2,
fileName='c:/main_2.ndf',
size=100MB,
maxsize=200MB,
filegrowth=20MB),

filegroup group1
(
name=group_1,
fileName='e:/group_1.ndf',
size=100MB,
maxsize=200MB,
filegrowth=20MB
),
(
name=mgroup_2,
fileName='e:/mgroup_2.ndf',
size=100MB,
maxsize=200MB,
filegrowth=20MB
)

log on
(
name=log1,
fileName='e:/log1.ldf',
size=5MB,
maxsize=25MB,
filegrowth=5MB
)

 

----更改默认文件组

 alter database testdb
modify filegroup group1 default