Problem Backing up a full CRM 4.0 database due to a missing full text catalogue after detach the database and attach RRS feed

  • Question

  • Hi

    I have moved the CRM 4.0 database in sql 2005 server using the detach and attach method to another drive on the server.  When I go to make a full backup of the CRM 4.0 database i receive the following error :-

    'System.Data.SqlClient.sqlerror: The backup of full text catalog 'ftcat_documentindex_bb3722df71904c7a9b17dd2ec431a209' is not permitted because it is not online.  Check error log gile 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. (Microsoft.sqlserver.smo).'

    The ftcat_documentindex_bb3722df71904c7a9b17dd2ec431a209 is under the Storage, Full Text Catalogs.  When I right mouse click and select Properties I receive this error message:-

    'Property FullTextIndexSize is not available for FullTextCatalog. '[ftcat_documentindex_bb3722df71904c7a9b17dd2ec431a209]' This property may not exist for this object, or may nor be retrievable due to insufficient access rights'.

    This is not affecting the CRM 4.0 users but I really need to make full backups of these databases for obvious reasons so how can I get the FullTextCatlog recreated ???? 




    Wednesday, July 21, 2010 1:34 PM


  • Hi,

    My guess is that you have a full text catalog that is 'off line'.  Check your full test catalogs in sql server.  You may have to 'rebuild' by going to yoru crm database, storage, then full text catalogs in sql server management studio.  There you can rebuild the catalog.

    Alex Fagundes - www.PowerObjects.com
    • Marked as answer by Jim Glass Jr Thursday, July 22, 2010 5:39 PM
    Wednesday, July 21, 2010 5:34 PM