22,302
社区成员




--第一步:创建文件组
ALTER DATABASE ERP3_MTX_U ADD FILEGROUP T_FG1;
ALTER DATABASE ERP3_MTX_U ADD FILEGROUP T_FG2;
ALTER DATABASE ERP3_MTX_U ADD FILEGROUP T_FG3;
--第二步:物理的数据存储
ALTER DATABASE ERP3_MTX_U ADD FILE (NAME = 'T_FG1', FILENAME = 'C:\T_FG1.NDF') TO FILEGROUP T_FG1;
ALTER DATABASE ERP3_MTX_U ADD FILE (NAME = 'T_FG2', FILENAME = 'C:\T_FG2.NDF') TO FILEGROUP T_FG2;
ALTER DATABASE ERP3_MTX_U ADD FILE (NAME = 'T_FG3', FILENAME = 'C:\T_FG3.NDF') TO FILEGROUP T_FG3;
--第三步:创建分区函数
CREATE PARTITION FUNCTION FU_PU100A(datetime) AS RANGE LEFT FOR VALUES ('01/01/2010','01/01/2011','01/01/2012')
--第四步:创建分区架构
CREATE PARTITION SCHEME SC_PU100A AS PARTITION FU_PU100A TO (T_FG1,T_FG2,T_FG3)