Results 1 to 4 of 4

Thread: moving NDF file between filegroups

  1. #1
    Join Date
    Oct 2002
    Posts
    18

    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?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Try using DBCC SHRINKFILE with EMPTYFILE option to move data from .NDF to .MDF, then try to delete the file.

  3. #3
    Join Date
    Oct 2002
    Posts
    18
    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.

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    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
  •