I´m working with sql server 2000 and I have a 180Gb production database.
The company wants to split the database in 3 datafiles and they want to put some tables in an especific datafile.
For example, Catalog Tables in the mdf, user tables using the second file (ndf1) and the rest in the last file (ndf2).
How can I restore or move tables from one file to tree?, is it possible to especify what tables on which file?
Thanks for your suggestions