how to change drive for Partitioned tables I have a large table should have been partitioned in different derives but all of them in one drive (D:\sql\import2006.ndf), (D:\sql\import2007.ndf).how can i move them in to their own drives like data2006,data2007 etc without loosing data.
You are using the terminology incorrectly and is not clear what you want to achieve. A table has one or more partitions. Each partition resides in a filegroup. A filegroup hase one or more files. A file is stored on a logical drive. A logical drive can be backed by one or more physical drives.

What is that you want to change? 


Did you load data in the wrong partition of the table? 
Did you load the data in an unpartitioned table and now you need it to be partitioned? (This is really the same question as the first one) 
Did you placed the partition in the wrong filegroup?
Did you place one or more filegroup files on the wrong logical drive?
Did you place a logical drive on the wrong physical drive?


Each problem has a different solution.