ALTER DATABASE opcdatabase add file (name='fg1', filename = 'd:\fg1.ndf') to filegroup f1
ALTER DATABASE opcdatabase add file (name='fg2', filename = 'd:\fg2.ndf') to filegroup f2你把这部分改成我这样
ALTER DATABASE opcdatabase add file (name='fg2', filename = 'd:\fg2.ndf') to filegroup f2你把这部分改成我这样
ALTER DATABASE opcdatabase ADD FILEGROUP fg1;
ALTER DATABASE opcdatabase ADD FILEGROUP fg2;
go
ALTER DATABASE opcdatabase add file (name='fg1', filename = 'c:\fg1.ndf') to filegroup fg1
ALTER DATABASE opcdatabase add file (name='fg2', filename = 'c:\fg2.ndf') to filegroup fg2create partition function divideitemdata(time) as range right for values('2014-01-14 09:27:00');
go
CREATE PARTITION SCHEME schemeitemdata AS PARTITION divideitemdata TO (fg1, fg2);