22,210
社区成员
发帖
与我相关
我的任务
分享
--添加所有玩法的文件分组
USE master
ALTER DATABASE db_aa ADD FILEGROUP PTYPE_FILE_GROUP
--创建ndf文件
go
ALTER DATABASE db_aa ADD FILE
( NAME = N'fg1', FILENAME = N'e:\DeanData\fg1.ndf' , SIZE = 3072KB , FILEGROWTH = 1024KB ) TO FILEGROUP PTYPE_FILE_GROUP
ALTER DATABASE db_aa ADD FILE
( NAME = N'fg2', FILENAME = N'e:\DeanData\fg2.ndf' , SIZE = 3072KB , FILEGROWTH = 1024KB ) TO FILEGROUP PTYPE_FILE_GROUP
ALTER DATABASE db_aa ADD FILE
( NAME = N'fg3', FILENAME = N'e:\DeanData\fg3.ndf' , SIZE = 3072KB , FILEGROWTH = 1024KB ) TO FILEGROUP PTYPE_FILE_GROUP
ALTER DATABASE db_aa ADD FILE
( NAME = N'fg4', FILENAME = N'e:\DeanData\fg4.ndf' , SIZE = 3072KB , FILEGROWTH = 1024KB ) TO FILEGROUP PTYPE_FILE_GROUP
--到 db_aa数据库中操作
use db_aa
go
--创建分区函数
CREATE PARTITION FUNCTION customer_partfunc (int)
AS RANGE RIGHT
FOR VALUES (10,20,30)
go
--创建分区架构
CREATE PARTITION SCHEME customer_partscheme AS PARTITION customer_partfunc TO (fg1,fg2,fg3,fg4);
go