为已有的表做分区的问题!

Question

ALTER TABLE iemis.iesc21d1 
ADD 
PRIMARY KEY NONCLUSTERED(sc_rcno) 
ON PS_test(sc_rcno) 
GO 
======没有为文件组 "Teaching200606" 分配文件。只有添加文件后，才能在此文件组上填充表、索引和 text 列、ntext 列和 image 列。

Answer 1

没有为文件组 "Teaching200606" 分配文件。只有添加文件后，才能在此文件组上填充表、索引和 text 列、ntext 列和 image 列。

Answer 2

但我不知道怎么给文件组 "Teaching200606" 分配文件啊!!

Answer 3

create PARTITION SCHEME PS_test
AS PARTITION PF_test
 TO( 
    [Teaching200606],
    [Teaching200607],
    [Teaching200608],
    [Teaching200609],
    [Teaching200610],
    [Teaching200611],
    [Teaching200612],
    [Teaching200701],
    [Teaching200702],
    [Teaching200703],
    [Teaching200704],
    [Teaching200705],
    [Teaching200706],
    [Teaching200707],
    [Teaching200708],
    [Teaching200709],
    [Teaching200710],
    [Teaching200711],
    [Teaching200712],
    [Teaching200801],
    [Teaching200802],
    [Teaching200803],
    [Teaching200804],
    [Teaching200805],
    [Teaching200806],
    [Teaching200807],
    [Teaching200808],
    [Teaching200809],
    [Teaching200810],
    [Teaching200811],
    [Teaching200812],
    [Teaching200901],
    [Teaching200902],
    [Teaching200903],
    [Teaching200904],
[Teaching200905]
)CREATE PARTITION FUNCTION PF_test(varchar(12))
AS RANGE LEFT
FOR VALUES(
'D606000000',
'D607000000',
'D608000000',
'D609000000',
'D610000000',
'D611000000',
'D612000000',
'D701000000',
'D702000000',
'D703000000',
'D704000000',
'D705000000',
'D706000000',
'D707000000',
'D708000000',
'D709000000',
'D710000000',
'D711000000',
'D712000000',
'D801000000',
'D802000000',
'D803000000',
'D804000000',
'D805000000',
'D806000000',
'D807000000',
'D808000000',
'D809000000',
'D810000000',
'D811000000',
'D812000000',
'D901000000',
'D902000000',
'D903000000',
'D904000000'
)
我建立好了这些..然后
ALTER TABLE iemis.iesc21d1 
ADD 
PRIMARY KEY NONCLUSTERED(sc_rcno) 
ON PS_test(sc_rcno) 
GO 

Answer 4

ALTER DATABASE db
    ADD FILEGROUP [Teaching200606];--添加文件到文件组中。
ALTER DATABASE db
    ADD FILE (name='xx',filename='x:\xx.ldf') TO FILEGROUP [Teaching200606];然后再分区架构里使用这个文件组。