InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 18:28:54 GMT20http://www.sqlservercentral.com/Forums/Topic1407624-391-1.aspxI create one file group for each file. Actually that kind of issue will give you error right away. My script ran for more than a day without any output. Now the problem has become more critical. I stopped the script and the rollback is running more than 12 hours.I am DEAD...Wed, 16 Jan 2013 07:30:18 GMTswaroop.sahoohttp://www.sqlservercentral.com/Forums/Topic1407624-391-1.aspx[quote]ALTER DATABASE DBName ADD FILE (NAME =F_TBL_201301,FILENAME ="<location>\F_TBL_201301.ndf", SIZE = 50MB, MAXSIZE = unlimited, FILEGROWTH = 10% ) TO FILEGROUP FG_TBLALTER PARTITION SCHEME PS_TBL NEXT USED [F_TBL_201301];ALTER PARTITION FUNCTION PF_MSCRaw() SPLIT RANGE (20130131)[/quote]Your NEXT USED is suppose to specify the filegroup and not the actual file.[code="sql"]ALTER DATABASE DBNameADD FILEGROUP FG_TBL_201301;GOALTER DATABASE DBNameADD FILE (NAME =F_TBL_201301,FILENAME ='C:\F_TBL_201301.ndf',SIZE = 50MB, MAXSIZE = unlimited, FILEGROWTH = 10%) TO FILEGROUP FG_TBL_201301;GOALTER PARTITION SCHEME PS_TBL NEXT USED [FG_TBL_201301];GOALTER PARTITION FUNCTION PF_MSCRaw() SPLIT RANGE (20130131)[/code]Wed, 16 Jan 2013 07:19:57 GMTWant a cool Sighttp://www.sqlservercentral.com/Forums/Topic1407624-391-1.aspxHi All,I have monthly partition (Size 150 GB per month). I forgot to create partition for January-2013. So all the January Data went to the dummy partition I created for the last range. As microsoft recomends the last partition should be empty.I tried to create a partition for January and get the data in the dummy partition to the newly created partition. But the script ran for more than a day without any data transfer. I am not sure how to create new partitions for the table now. The server is having 32 cores and 128GB memory. So I don't think transfering 50GB data (till Jan 12th) witll be a problem for it.MY Script::ALTER DATABASE DBName ADD FILE (NAME =F_TBL_201301,FILENAME ="<location>\F_TBL_201301.ndf", SIZE = 50MB, MAXSIZE = unlimited, FILEGROWTH = 10% ) TO FILEGROUP FG_TBLALTER PARTITION SCHEME PS_TBL NEXT USED [F_TBL_201301];ALTER PARTITION FUNCTION PF_MSCRaw() SPLIT RANGE (20130131)Masters.....CAN ANYBODY HELP???-SwaroopTue, 15 Jan 2013 23:47:26 GMTswaroop.sahoo