Sunday, May 23, 2010

Removing Full Text Catalog .ndf File from Database

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:

  1. Remove full text catalog from Database > Storage > Full Text Catalogs in Management Studio.
  2. Run
    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.

No comments: