复制--1.创建文件组 ALTERDATABASE [sss] ADD FILEGROUP [FG_TinyBlog_Id_01] ALTERDATABASE [sss] ADD FILEGROUP [FG_TinyBlog_Id_02] ALTERDATABASE [sss] ADD FILEGROUP [FG_TinyBlog_Id_03] ALTERDATABASE [sss] ADD FILEGROUP [FG_TinyBlog_Id_04] ALTERDATABASE [sss] ADD FILEGROUP [FG_TinyBlog_Id_05] --2.创建文件 ALTERDATABASE [sss] ADD FILE (NAME = NFG_TinyBlog_Id_01_data,分区FILENAME = NE:\DataBase\sss\FG_TinyBlog_Id_01_data.ndf,SIZE = 96MB, FILEGROWTH = 24MB ) TO FILEGROUP [FG_TinyBlog_Id_01]; ALTERDATABASE [sss] ADD FILE (NAME = NFG_TinyBlog_Id_02_data,FILENAME = NE:\DataBase\sss\FG_TinyBlog_Id_02_data.ndf,SIZE = 96MB, FILEGROWTH = 24MB ) TO FILEGROUP [FG_TinyBlog_Id_02]; ALTERDATABASE [sss] ADD FILE (NAME = NFG_TinyBlog_Id_03_data,FILENAME = NE:\DataBase\sss\FG_TinyBlog_Id_03_data.ndf,SIZE = 96MB, FILEGROWTH = 24MB ) TO FILEGROUP [FG_TinyBlog_Id_03]; ALTERDATABASE [sss] ADD FILE (NAME = NFG_TinyBlog_Id_04_data,FILENAME = NE:\DataBase\sss\FG_TinyBlog_Id_04_data.ndf,SIZE = 96MB, FILEGROWTH = 24MB ) TO FILEGROUP [FG_TinyBlog_Id_04]; ALTERDATABASE [sss] ADD FILE (NAME = NFG_TinyBlog_Id_05_data,FILENAME = NE:\DataBase\sss\FG_TinyBlog_Id_05_data.ndf,SIZE = 96MB, FILEGROWTH = 24MB ) TO FILEGROUP [FG_TinyBlog_Id_05]; --3.创建分区函数 CREATE PARTITION FUNCTION Fun_TinyBlog_Id(INT) AS RANGE LEFT FORVALUES(-10,0,1,6) --4.创建分区方案 CREATE PARTITION SCHEME [Sch_TinyBlog_Id] AS PARTITION [Fun_TinyBlog_Id] TO([FG_TinyBlog_Id_01],[FG_TinyBlog_Id_02],[FG_TinyBlog_Id_03],[FG_TinyBlog_Id_04],[FG_TinyBlog_Id_05]) 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56. |
喜欢
讨厌