ALTER DATABASE PerfmonHistory
ADD FILEGROUP [FG25]
GO


ALTER DATABASE PerfmonHistory 	
ADD FILE 	  
 	(NAME = N'PerformanceHistoryFG25File1',
        FILENAME = N'C:\PerfmonHistory\PerformanceHistoryFG25File1.ndf',
  	SIZE = 1MB,
        MAXSIZE = 100MB,
        FILEGROWTH = 5MB) 
TO FILEGROUP [FG25]
GO


ALTER PARTITION SCHEME TwoYearDateRangePScheme NEXT USED [FG25]
GO

-------------------------------------------------------
-- Alter the partition function to add the new range
-------------------------------------------------------
ALTER PARTITION FUNCTION TwoYearDateRangePFN() 
SPLIT RANGE ('2015-07-18 09:34:05.410')
GO 

--2015-07-18 09:34:05.410