--给文件组创建文件 alter database NewDB add file (name=NewDB _File_1',filename='G:\DB\NewDB \NewDB _File_1.ndf',maxsize=UNLIMITED,filegrowth=10%) to filegroup [NewDB _FileGroup_G] alter database NewDB add file (name=NewDB _File_2',filename='G:\DB\NewDB \NewDB _File_2.ndf',maxsize=UNLIMITED,filegrowth=10%) to filegroup [NewDB _FileGroup_G] alter database NewDB add file (name=NewDB _File_3',filename='G:\DB\NewDB \NewDB _File_3.ndf',maxsize=UNLIMITED,filegrowth=10%) to filegroup [NewDB _FileGroup_H]把你的代码贴到查询编译器中发现在NewDB_File_1后面多了一个单引号,2 3 也同样,另外NewDB后面多了一个空格,不知道是你代码本来是这样还是贴过来的时候变这样了,检查一下吧
单引号是贴代码的手误。空格也是手误.... 我今天又试了下,还是报错。我贴一点代码你们看 --创建文件组 alter database NewDB add filegroup [DB_FileGroup_20110101] alter database NewDB add filegroup [DB_FileGroup_20110401] --给文件组创建文件 alter database NewDB add file (name='NewDB_File_20110101',filename='D:\DB\NewDB\NewDB_File_20110101.ndf',maxsize=UNLIMITED,filegrowth=10%) to filegroup NewDB_FileGroup_20110101 alter database NewDB add file (name='NewDB_File_20110401',filename='D:\DB\NewDB\NewDB_File_20110401.ndf',maxsize=UNLIMITED,filegrowth=10%) to filegroup NewDB_FileGroup_20110401 --创建分区函数 Create Partition Function Demo_PartFun(datetime) as range left for values( ‘20110101’,‘20110401’ ) --创建分区方案 Create Partition SCHEME Demo_PartSCH as partition Demo_PartFun To( [NewDB_FileGroup_20110101], [NewDB_FileGroup_20110401]) 在创建分区方案的时候提示,对象名‘NewDB_FileGroup_20110101’无效
--1 是注释 我创建的分组比较多,我为了记住有多少加的注释--创建文件组 alter database NewDB add filegroup [DB_FileGroup_20110101] alter database NewDB add filegroup [DB_FileGroup_20110401] --分两步走别偷懒 --给文件组创建文件 ALTER DATABASE [NewDB] ADD FILEGROUP [NewDB_FileGroup_20110101] GO ALTER DATABASE [NewDB] ADD FILEGROUP [NewDB_FileGroup_20110401] GO --给文件组添加文件 alter database NewDB add file (name=NewDB_File_20110101,filename='E:\DB\NewDB\NewDB_File_20110101.ndf',SIZE=5MB,maxsize=UNLIMITED,filegrowth=10%) to filegroup [NewDB_FileGroup_20110101]; alter database NewDB add file (name=NewDB_File_20110401,filename='E:\DB\NewDB\NewDB_File_20110401.ndf',SIZE=5MB,maxsize=UNLIMITED,filegrowth=10%) to filegroup [NewDB_FileGroup_20110401]; --创建分区函数 Create Partition Function Demo_PartFun(datetime) as range left for values( '20110101','20110401') --创建分区方案 Create Partition SCHEME Demo_PartSCH as partition Demo_PartFun To( [NewDB_FileGroup_20110101], [NewDB_FileGroup_20110101],--如果要在同一分区也要指定多次 [NewDB_FileGroup_20110401])
Create Partition Function Demo_PartFun(int)
as range left for values(
5000000,--1
100000 00
)这个是不是有问题呢,--1是什么意思
alter database NewDB add file
(name=NewDB _File_1',filename='G:\DB\NewDB \NewDB _File_1.ndf',maxsize=UNLIMITED,filegrowth=10%) to filegroup [NewDB _FileGroup_G]
alter database NewDB add file
(name=NewDB _File_2',filename='G:\DB\NewDB \NewDB _File_2.ndf',maxsize=UNLIMITED,filegrowth=10%) to filegroup [NewDB _FileGroup_G]
alter database NewDB add file
(name=NewDB _File_3',filename='G:\DB\NewDB \NewDB _File_3.ndf',maxsize=UNLIMITED,filegrowth=10%) to filegroup [NewDB _FileGroup_H]把你的代码贴到查询编译器中发现在NewDB_File_1后面多了一个单引号,2 3 也同样,另外NewDB后面多了一个空格,不知道是你代码本来是这样还是贴过来的时候变这样了,检查一下吧
单引号是贴代码的手误。空格也是手误....
我今天又试了下,还是报错。我贴一点代码你们看
--创建文件组
alter database NewDB add filegroup [DB_FileGroup_20110101]
alter database NewDB add filegroup [DB_FileGroup_20110401]
--给文件组创建文件
alter database NewDB add file
(name='NewDB_File_20110101',filename='D:\DB\NewDB\NewDB_File_20110101.ndf',maxsize=UNLIMITED,filegrowth=10%) to filegroup NewDB_FileGroup_20110101
alter database NewDB add file
(name='NewDB_File_20110401',filename='D:\DB\NewDB\NewDB_File_20110401.ndf',maxsize=UNLIMITED,filegrowth=10%) to filegroup NewDB_FileGroup_20110401
--创建分区函数
Create Partition Function Demo_PartFun(datetime)
as range left for values(
‘20110101’,‘20110401’
)
--创建分区方案
Create Partition SCHEME Demo_PartSCH
as partition Demo_PartFun
To(
[NewDB_FileGroup_20110101],
[NewDB_FileGroup_20110401])
在创建分区方案的时候提示,对象名‘NewDB_FileGroup_20110101’无效
alter database NewDB add filegroup [DB_FileGroup_20110101]
alter database NewDB add filegroup [DB_FileGroup_20110401]
--分两步走别偷懒
--给文件组创建文件
ALTER DATABASE [NewDB] ADD FILEGROUP [NewDB_FileGroup_20110101]
GO
ALTER DATABASE [NewDB] ADD FILEGROUP [NewDB_FileGroup_20110401]
GO
--给文件组添加文件
alter database NewDB add file
(name=NewDB_File_20110101,filename='E:\DB\NewDB\NewDB_File_20110101.ndf',SIZE=5MB,maxsize=UNLIMITED,filegrowth=10%) to filegroup [NewDB_FileGroup_20110101];
alter database NewDB add file
(name=NewDB_File_20110401,filename='E:\DB\NewDB\NewDB_File_20110401.ndf',SIZE=5MB,maxsize=UNLIMITED,filegrowth=10%) to filegroup [NewDB_FileGroup_20110401];
--创建分区函数
Create Partition Function Demo_PartFun(datetime)
as range left for values(
'20110101','20110401')
--创建分区方案
Create Partition SCHEME Demo_PartSCH
as partition Demo_PartFun
To(
[NewDB_FileGroup_20110101],
[NewDB_FileGroup_20110101],--如果要在同一分区也要指定多次
[NewDB_FileGroup_20110401])