ALTER DATABASE DBName ADD FILE
(NAME =F_TBL_201301,FILENAME ="<location>\F_TBL_201301.ndf",
SIZE = 50MB, MAXSIZE = unlimited, FILEGROWTH = 10%
) TO FILEGROUP FG_TBL
ALTER PARTITION SCHEME PS_TBL NEXT USED [F_TBL_201301];
ALTER PARTITION FUNCTION PF_MSCRaw() SPLIT RANGE (20130131)
Your NEXT USED is suppose to specify the filegroup and not the actual file.
ALTER DATABASE DBName
ADD FILEGROUP FG_TBL_201301;
GO
ALTER DATABASE DBName
ADD FILE
(NAME =F_TBL_201301,
FILENAME ='C:\F_TBL_201301.ndf',
SIZE = 50MB,
MAXSIZE = unlimited,
FILEGROWTH = 10%
) TO FILEGROUP FG_TBL_201301;
GO
ALTER PARTITION SCHEME PS_TBL NEXT USED [FG_TBL_201301];
GO
ALTER PARTITION FUNCTION PF_MSCRaw() SPLIT RANGE (20130131)
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D