neerav.saini (6/24/2009)
hi all,In my database i want to create new *.mdf file and i want to transfer selected tables frmo old mdf to new one.Is this possible?
If yes how to create and how to move data from old mdf to new mdf?
Thanks,
Neerav
If i understand you, think you are talking about adding aditional datafiles (segment/partitions). This can be done and relatively eaasily. Why do you want to do this though?
Or have i misunderstood. Either way look at BOL under 'Data partition'. 🙂
Adam Zacks-------------------------------------------Be Nice, Or Leave