how to delete database file(.ndf) and moving data to another available files?

• anzz

  SSCertifiable

  Points: 5503

  More actions

  September 14, 2012 at 8:26 am

  #393179

  how to delete database file(.ndf) and moving data to another available files?

• Gazareth

  One Orange Chip

  Points: 27737

  More actions

  September 14, 2012 at 9:08 am

  #1537927

  Use DBCC SHRINKFILE with the EMPTYFILE option to move all data out, then use ALTER DATABASE to delete the file.

  http://msdn.microsoft.com/en-us/library/ms189493.aspx