June 3, 2002 at 9:43 pm
I am trying to improve database performance by adding a new filegroup to an existing database on a different drive. Can I move an existing table to the new filegroup, by Alter table statement, or I have to drop the table and recreate it. Also, by having multiple filegroups, what issues do I have to watch out for.
I would appreciate any advise you can give me.
June 4, 2002 at 5:07 am
I am not sure you can do this thru ALTER TABLE and generally I do it thru EM as if their on constraints and permissions it will take care of copying those over. Backup restores when you do filegroup backups was the funnest I had to do, but they were easy. Other than that I have not run into anything specific. Also have heard a few folks complain about issues with dropping filegroups for whatever reason (usually a historical filegroup and the data is no longer needed). There are a few threads on this if you search for filegroup.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply