Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Renaming a filegroup Expand / Collapse
Author
Message
Posted Tuesday, April 15, 2014 10:27 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, October 16, 2014 6:18 PM
Points: 3,961, Visits: 7,170
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; They'll drag you down to their level and beat you with experience"
Post #1561968
Posted Wednesday, April 16, 2014 5:06 AM This worked for the OP Answer marked as solution


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:12 PM
Points: 6,490, Visits: 13,967
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"


  Post Attachments 
fgs.jpg (31 views, 108.41 KB)
Post #1562231
Posted Wednesday, April 16, 2014 7:32 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, October 16, 2014 6:18 PM
Points: 3,961, Visits: 7,170
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; They'll drag you down to their level and beat you with experience"
Post #1562287
Posted Wednesday, April 16, 2014 9:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:12 PM
Points: 6,490, Visits: 13,967
you're welcome

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1562351
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse