Don’t know how but one of my databases ended up having one extra file (.ndf) which, apparently, contained full-text index. Since I don’t need that and I’m sure it was not there originally, I decided to amputate it from the database. To do this, I had to do the following:
- Remove full text catalog from Database > Storage > Full Text Catalogs in Management Studio.
use DatabaseName dbcc shrinkfile('ftrow_DatabaseName_Catalog', EMPTYFILE)
alter database DatabaseName remove file ftrow_DatabaseName_Catalog
This removed the .ndf file from the database storage files.