Backup is failing because of full text catalog is offline

• balbirsinghsodhi

  SSCrazy Eights

  Points: 9210

  More actions

  December 16, 2008 at 12:11 am

  #126538

  I have deleted full text index on one of the table but I still see the entry in the sys.master_files and the catalog is offline. How to delete the entry from the sys.master_files so that I can create a new text index and make it online.

  SELECT name, physical_name AS CurrentLocation, state_desc

  FROM sys.master_files

  WHERE database_id = DB_ID(N'PMG_MSCRM');

• balbirsinghsodhi

  SSCrazy Eights

  Points: 9210

  More actions

  December 16, 2008 at 2:29 pm

  #913458

  This issue is fixed.

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  December 16, 2008 at 3:44 pm

  #913488

  Can you please share the solution?

  Mj

• balbirsinghsodhi

  SSCrazy Eights

  Points: 9210

  More actions

  December 16, 2008 at 3:57 pm

  #913494

  Here what I did.

  -- First use database you are looking for.Then run as below

  SELECT name, ftcatid FROM sysobjects WHERE ftcatid > 0

  -- For each returning table name that has the table with Full-Text Index,

  -- run below command:

  EXEC sp_fulltext_table 'DocumentIndex', 'drop'

  -- After droping the Full-Text Catalog

  --GET CATALOG

  SELECT * FROM sys.fulltext_catalogs

  -- DROP CATALOG

  DROP FULLTEXT CATALOG ftcat_documentindex_00b573ed1d224ef78db16016caa1eb35