Moss 2007 Migration [Part2] – Check errorlog file for the reason that full-text catalog became offline and bring it online

23 באוגוסט 2007

תגיות: , ,
5 תגובות

In my pervious post I mentioned a Moss 2007 64Bit Migration Experience , well here's the follow up : Ok , so we had an INDEX problem that was inherited from the Sharepoint 2003 Version. The Problem was that we got on our main 'spscontentdb' database:

"Object spscontentdb failed in event OnBackup. For more information, see the error log located in the backup directory. SqlException: The backup of full-text catalog 'ix_SPSPortal_SITE_db' 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."

Steps take to resolve the problem:

  1. SELECT * FROM sysfulltextcatalogs – which gave us the FCTATID , NAME , STATUS , PATH. I took a look if the path existed and – No , it didn't exist. so the Index is poiniting to a non exsiting File/Directory. Seeing that most of the Articles I came accross told me to remove the index I have decided to take this corse of action – drop the index.
  2. Ok, now I have to drop the index. Have it's name did the following: DROP FULLTEXT CATALOG ix_SPSPortal_SITE_db.  Where "ix_SPSPortal_SITE_db" is the name of the catalog.
  3. Now try again to backup the Farm. Don't forget that the backup directory name should be a UNC path for example \\xmoss\backup\ , and that the User who runs the SqlServer Service has write permission
  4. don't forget the Complete reference of all STSADM operations (with parameters) in MOSS 2007
הוסף תגובה
facebook linkedin twitter email

כתיבת תגובה

האימייל לא יוצג באתר. שדות החובה מסומנים *

5 תגובות

  1. Michael Griffin21 בספטמבר 2007 ב 22:44

    when I do
    DROP FULLTEXT CATALOG ix_SPSPortal_SITE_db. Where "ix_SPSPortal_SITE_db" is the name of the catalog.
    it returns an error that the Full Text Catalog must be dropped. … and that is what the sql statement is ran for.. to drop it. So I'm not really sure what else to do for myself to continue past this error that I receive when a back up one database out of 12.

    הגב
  2. Michael Griffin21 בספטמבר 2007 ב 22:45

    The exact error:
    Msg 7668, Level 16, State 1, Line 1
    Cannot drop full-text catalog 'ix_ZeeNet3_SITE' because it contains a full-text index.
    Any ideas?!

    הגב
  3. Garry Hutchings10 באפריל 2008 ב 13:57

    Hi, Thanks for this post, I’ve been trying to sort out this error for ages, After running DROP FULLTEXT CATALOG ix_MySiteName_SITE_db my backups ran without error, Thanks again.
    Garry

    הגב
  4. Senthil12 בינואר 2010 ב 17:53

    That worked for me too. Thanks a lot!

    הגב