1 alter database rfdb add filegroup rf_test1
2 alter database rfdb add filegroup rf_test2
3 alter database rfdb add filegroup rf_test3
4
5 alter database rfdb add file(name='rf_test1',filename='D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\rf_test1.ndf',size=5MB,maxsize=100MB,filegrowth=5Mb) to filegroup rf_test1
6 alter database rfdb add file(name='rf_test2',filename='D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\rf_test2.ndf',size=5MB,maxsize=100MB,filegrowth=5Mb) to filegroup rf_test2
7 alter database rfdb add file(name='rf_test3',filename='D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\rf_test3.ndf',size=5MB,maxsize=100MB,filegrowth=5Mb) to filegroup rf_test3
8 go
9
10 create partition function partfunrft(datetime) as range left for values ('2010-01-01','2011-01-01')
11 create partition scheme partsherft as partition partfunrft to (rf_test1,rf_test2,rf_test3)
