Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aiken
Aged Yak Warrior
525 Posts |
 Posted - 2003-03-13 : 23:16:14
|
| Way back when, I made a bit of a mess with filegroups. At this point, I'm in the process of transitioning to new hardware, so this seems an ideal time for cleaning up.However, I can't seem to find how to get rid of a filegroup once it's created. I'd really like to get my database down to just a single filegroup again, transfer it to the new server, and then do filegroups the right way. Is there any way to condense all filegroups into primary? Even if I do it manually, is there any way to remove the filegroups once they're not being used? Can I just not attach them, or is that scary?Thanks-b |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-14 : 04:30:46
|
| Will ALTER DATABASE command do? I never tried that.BOL Says..MODIFY FILEGROUP filegroup_name { filegroup_property | NAME = new_filegroup_name }Specifies the filegroup to be modified and the change needed. If filegroup_name and NAME = new_filegroup_name are specified, changes the filegroup name to the new_filegroup_name.Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
|
|
|
Getting rid of filegroups?