--DROP PARTITION FUNCTION TestPartition
CREATE PARTITION FUNCTION TestPartition (int)
AS RANGE LEFT FOR VALUES (1000000, 2000000,3000000);
ALTER DATABASE test ADD FILEGROUP [P1]
ALTER DATABASE test ADD FILEGROUP [P2]
ALTER DATABASE test ADD FILEGROUP [P3]
ALTER DATABASE test
ADD FILE
(NAME = N'P1',FILENAME = N'D:\P1.ndf',SIZE = 100MB,FILEGROWTH = 100MB)
TO FILEGROUP [P1]
ALTER DATABASE test
ADD FILE
(NAME = N'P2',FILENAME = N'D:\P2.ndf',SIZE = 100MB,FILEGROWTH = 100MB)
TO FILEGROUP [P2]
ALTER DATABASE test
ADD FILE
(NAME = N'P3',FILENAME = N'D:\P3.ndf',SIZE = 100MB,FILEGROWTH = 100MB)
TO FILEGROUP [P3]
--DROP PARTITION SCHEME [TestPartitionScheme]
CREATE PARTITION SCHEME [TestPartitionScheme]
AS
PARTITION TestPartition TO
(
[P1],[P2],[P3],[PRIMARY]
)
CREATE PARTITION FUNCTION TestPartition (int)
AS RANGE LEFT FOR VALUES (1000000, 2000000,3000000);
ALTER DATABASE test ADD FILEGROUP [P1]
ALTER DATABASE test ADD FILEGROUP [P2]
ALTER DATABASE test ADD FILEGROUP [P3]
ALTER DATABASE test
ADD FILE
(NAME = N'P1',FILENAME = N'D:\P1.ndf',SIZE = 100MB,FILEGROWTH = 100MB)
TO FILEGROUP [P1]
ALTER DATABASE test
ADD FILE
(NAME = N'P2',FILENAME = N'D:\P2.ndf',SIZE = 100MB,FILEGROWTH = 100MB)
TO FILEGROUP [P2]
ALTER DATABASE test
ADD FILE
(NAME = N'P3',FILENAME = N'D:\P3.ndf',SIZE = 100MB,FILEGROWTH = 100MB)
TO FILEGROUP [P3]
--DROP PARTITION SCHEME [TestPartitionScheme]
CREATE PARTITION SCHEME [TestPartitionScheme]
AS
PARTITION TestPartition TO
(
[P1],[P2],[P3],[PRIMARY]
)