How to merge 2 data files?

  • Dear all,

    I created a ndf file by mistake and it was filled with data. Now, I want to remove the file. How can I merge the data of it and then remove it?

    Thanks,

    coby

  • Hi, use the dbcc shrinkfile with option 'emptyfile' in the .ndf file to merge data in .mdf file.

     




    Cesar Justi - DBA

  • Thanks a lot. This did work. -: ) coby

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply