InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 07:59:26 GMT20http://www.sqlservercentral.com/Forums/Topic809671-145-1.aspxI am also having issues with modifying partition schemes using existing data. Here's what I have done:1. Created filegroup and added files2. ALTER PARTITION SCHEME partition_scheme_name NEXT USED filegroup_name3. ALTER PARTITION FUNCTION partition_function_name SPLIT RANGE (value).What happened is that SQL Server moved the existing data from one filegroup to another. When I look at the partition scheme it does not appear that the new filegroup is included.Tue, 15 Dec 2009 06:58:05 GMTcathy.bakerhttp://www.sqlservercentral.com/Forums/Topic809671-145-1.aspxHi Expert,I would like to know how will I alter the my partition scheme and function if it has already data on it. :hehe:Tue, 27 Oct 2009 17:37:54 GMTmcvilbar