How to merge 2 data files?

• coby_cai

  SSC-Addicted

  Points: 439

  More actions

  November 7, 2006 at 5:53 pm

  #170956

  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

• cjusti

  Grasshopper

  Points: 10

  More actions

  November 7, 2006 at 6:36 pm

  #670446

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

   

  
  
  
  Cesar Justi - DBA

• coby_cai

  SSC-Addicted

  Points: 439

  More actions

  November 7, 2006 at 7:18 pm

  #670447

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