-
moving NDF file between filegroups
I have a secondary data file (NDF) in a secondary filegroup, and, I'd like to consolidate the NDF back into the MDF again. First I have to move the NDF file between filegroups. I can't seem to find out how to do this. Any suggestions?
-
Try using DBCC SHRINKFILE with EMPTYFILE option to move data from .NDF to .MDF, then try to delete the file.
-
Thanks for the response,
I think that command requires that everything be in the same filegroup; in any case, I get this message:
--Server: Msg 1105, Level 17, State 2, Line 1
--Could not allocate space for object 'DFA_trans_mw2' in database 'ADVCPR' because the
--'SecondaryRW' filegroup is full.
-
You can move table from secondary filegroup to primary filegroup then delete secondary filegroup.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|