InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 04:42:39 GMT20http://www.sqlservercentral.com/Forums/Topic1357160-391-1.aspxAs I said, you cannot control what data goes onto what file when there are multiple files in a filegroup.Tue, 11 Sep 2012 05:28:15 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1357160-391-1.aspxIt is not possible to do a file level partition at this time.Tue, 11 Sep 2012 04:58:13 GMTBrandie Tarvinhttp://www.sqlservercentral.com/Forums/Topic1357160-391-1.aspxThanks All,Yes, I tested that it distributed data equally for all the files. My doubt is, whether it is possible to do file level partition.Tue, 11 Sep 2012 04:56:22 GMTk.thanigaivelhttp://www.sqlservercentral.com/Forums/Topic1357160-391-1.aspxIf there are two files in a filegroup, SQL spreads the data evenly across the two files, you cannot control which file in a filegroup gets what data.Tue, 11 Sep 2012 04:33:20 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1357160-391-1.aspxYou can't, really. Where the data resides is a function of the engine and the default filegroup. The best you can do for control purposes is to either create a CLUSTERED INDEX for a table on that filegroup or create a PARTITION SCHEME on the filegroup. The file distribution itself is out of your control, though. EDIT: What I mean by that last statement is I don't believe you can dictate more granular than filegroup.Tue, 11 Sep 2012 04:28:22 GMTBrandie Tarvinhttp://www.sqlservercentral.com/Forums/Topic1357160-391-1.aspxHi All,I have two filegroup named with primary and secondary filegroup. The secondary filegroup contains two files called Bet_2009.ndf and Bet_2010.ndf.My question is how to move data into different files based on the year?Tue, 11 Sep 2012 00:54:54 GMTk.thanigaivel