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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy