Renaming a filegroup
-
In one of our production databases a prior DBA made a typo when creating a new file group, does anyone know of any "issues" from renaming it? Specifically, does anything happen behind the scenes to the objects stored in the files attached to that file group? In my testing on a small dev server, I didn't notice anything out of sorts, but wanted to ask the group before actually running the code below on a larger system:
ALTER DATABASE [Sandbox]MODIFY FILEGROUP NCIindexes NAME =NCIndexes
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
-
The fact that there is an ALTER statement to achieve this should assure you it's a supported action 😉
Internally within the system, filegroups are referenced by their allocated id "data_space_id" and not their name, as shown below
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
Thanks Perry. I realize it was supported, just wanted to make certain there was no "behind the scenes" issues with the rename. Appreciate the assurance!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
-
you're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply