Pages

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: