June 2, 2006 at 1:42 pm
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
June 5, 2006 at 6:36 am
You can specify which tables go on which filegroup, so if your data files are in different filegroups from each other then you will be able to do what you're asking for.
You have two choices: (1) drop the clustered index for each table (if it exists) and rebuild it on the new filegroup or (2) right-click on the table in Enterprise Manager, choose Design Table, right-click on any of the column specifications and choose Properties, and change Table Filegroup to the new filegroup. Option 2 is very tedious if you have a lot of tables, and won't work if the table is used for replication.
John
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply