Backup failing : "The backup of full-text catalog 'QCFTCAT' is not permitted because it is not online.

• Senthil-489003

  Old Hand

  Points: 337

  More actions

  February 3, 2011 at 11:17 pm

  #142285

  Hi All

  My database backup is suddenly failing and below is the error log. It was working fine for past one years.

  " failed with the following error: "The backup of full-text catalog 'QCFTCAT' is not permitted because it is not online. Check errorlog file for the reason that full-text catalog became offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.

  BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

  Please let me know how to fix this error.

  Regards

  Senthil

• crazy4sql

  SSCoach

  Points: 19590

  More actions

  February 4, 2011 at 2:46 am

  #1282328

  is the database having filegroups(ndf)?

  If so, are all the file groups online when you taking backup.

  It could be the possibility that database have a specific filegroup which is configured on a different drive and that drive is no more accessible

  ----------
  Ashish

• Senthil-489003

  Old Hand

  Points: 337

  More actions

  February 4, 2011 at 2:57 am

  #1282329

  Hi All,

  I fixed the report issue as follows

  1)Put the database into single user mode.

  2)Detach the database. But before clicking OK for the detach, UNCHECK the Keep full text catalogs.

  3)Reattach the database

  Regards

  Senthil

• bindujanga229

  Grasshopper

  Points: 13

  More actions

  May 9, 2016 at 7:10 am

  #1877473

  I restored a SQL database from SQL 2000 to SQL 2005 and got this error during backup:

  "The backup of full-text catalog '' is not permitted because it is not online" as full text catalog was not restored.

  1. Ran below T-SQL and found catalog location is from old server which does not exist in new server and hence Catalog was offline.

  SELECT name, physical_name AS CurrentLocation, state_desc

  FROM sys.master_files

  WHERE database_id = DB_ID(N'databasename');

  2. Copy the folder form old server to new server. Change the path for catalog file:

  ALTER DATABASE dbname

  MODIFY FILE ( NAME = ******_Catalog , FILENAME = 'D:\SQL\*****_Catalog');

  3. Now verify the status and it should be online.

  SELECT name, physical_name AS CurrentLocation, state_desc

  FROM sys.master_files

  WHERE database_id = DB_ID(N'databasename');