locked
should i rebuild full text catalog daily? RRS feed

  • Question

  • i know that i should rebuild the full text index daily, but what about the catalog? should i rebuild it daily too?

    if it is, when is the suitable time for this to be done? after full text index rebuild of before?

    thank you.

    Thursday, August 15, 2013 1:53 AM

All replies

  • Hi,

    I don;t understand your questions :) kindly elaborate more in order to allow us to better help you.


    Guowen Su
    Cisco Certified Network Associate
    Cisco Certified Internetwork professional - MPLS
    Certified Information Systems Security Professional
    Microsoft Partner Network 2011
    Microsoft Certified Professional
    Microsoft Certified Systems Administrator:Security
    Microsoft Certified Systems Engineer: Security
    Microsoft Certified Technology Specialist: Windows Server 2008 Active Directory, Configuration
    Microsoft Certified Technology Specialist: Windows Server 2008 Network Infrastructure, Configuration
    Microsoft Certified Technology Specialist: Windows Server 2008 Applications Infrastructure, Configuration
    Microsoft Certified Technology Specialist: Windows 7, Configuring
    Microsoft Certified IT Professional: Enterprise Administrator
    Microsoft Certified IT Professional: Server Administrator
    Certified Ethical Hacker
    Computer Hacking Forensics Investigator
    Certified Sonicwall Security Administrator
    Microsoft Geeks

    Thursday, August 15, 2013 7:09 AM
  • oh, sorry...

    the situation is like this, i have a web based system (PHP, MS SQL, Windows Server 2008). i want to implement a full text search feature on one of the database, so i have created a catalog on the database and i have enabled full-text index on some of the table.

    from what i understand, i have to execute "start full population" command to populate the full-text index on each table daily so that new record can be found upon performing full-text search.

    but what i don't understand is, do i have to perform rebuild command on that database full-text catalog everyday too?

    Thursday, August 15, 2013 7:59 AM