Post reply

SQL Server 2008 Fulltext catalog not getting populated.

  • January 29, 2010 at 12:19 am

    #220139

    Its a great difficulty. I am using SQL Server 2008 and i have created a database in SQL Server 2005. I have added data in SQl server 2005. Now I have taken a backup in SQL Server 2005 and attached it with SQL server 2008 with service pack 1, but now i realise that the Full text catalog population has completely failed. Full text catalaog is not getting automatically bulit. At the beginning it was working fine, but after using the SQL server 2008 for 2 or 3 months, this problem has started. I have a data of some 20 tables and each table having atleast 20k + rows. Please help or let me know the solultion for this problem in SQL server @008 Service pack 1, Full text catalog not getting populated even after rebuilding it.

    Regards,

    Arnab Kumar Nath

  • January 29, 2010 at 8:02 am

    #1110754

    arnabnath2002 (1/29/2010)

    Its a great difficulty. I am using SQL Server 2008 and i have created a database in SQL Server 2005. I have added data in SQl server 2005. Now I have taken a backup in SQL Server 2005 and attached it with SQL server 2008 with service pack 1, but now i realise that the Full text catalog population has completely failed. Full text catalaog is not getting automatically bulit. At the beginning it was working fine, but after using the SQL server 2008 for 2 or 3 months, this problem has started. I have a data of some 20 tables and each table having atleast 20k + rows. Please help or let me know the solultion for this problem in SQL server @008 Service pack 1, Full text catalog not getting populated even after rebuilding it.

    Regards,

    Arnab Kumar Nath

    Full Text index only become native to the relational engine in SQL Server 2005 and I think it also changed between 2005 and 2008 so I think you need to make sure your database is compatibility 100 and drop the 20 indexes and re create them so all are native to SQL Server 2008. That is remove 2005 related features and use 2008.

    Kind regards,
    Gift Peddie

  • January 29, 2010 at 7:36 pm

    #1111087

    Hi Crazy, I have tried that too, but same result. Later, i just tried to check another process,I created a new database with four columns and five rows of data. Then I created a Full Text index for this new database and its table, but I was surprised to see that still the Full Text Index is not populating at all. Is it a problem in the SQL server 2008 software or is it an installation problem? I have already reinstalled the software twice earlier. Please suggest.

    Arnab

  • January 29, 2010 at 7:43 pm

    #1111089

    arnabnath2002 (1/29/2010)

    Hi Crazy, I have tried that too, but same result. Later, i just tried to check another process,I created a new database with four columns and five rows of data. Then I created a Full Text index for this new database and its table, but I was surprised to see that still the Full Text Index is not populating at all. Is it a problem in the SQL server 2008 software or is it an installation problem? I have already reinstalled the software twice earlier. Please suggest.

    Arnab

    What edition of SQL Server if Express then maybe the service is off check configuration manager and make sure it is running

    Kind regards,
    Gift Peddie

  • January 29, 2010 at 10:43 pm

    #1111122

    Hi Crazy, you are right, I have checked SQL Full-Text ,Start Mode is Automatic, Log ON As NT Authority/Local Service ,but the Service Type Column is blank.

    i am attaching a link , which shows the Screen shot of Configuration manager. Also i can send u screenshots of the areas which you require. Please suggest.

    Arnab

  • January 30, 2010 at 8:39 am

    #1111189

    It is not running so right click on it and change the account to either Local systems or Network service, do the same for the browser service and all the services not running in your configuration manager.

    Kind regards,
    Gift Peddie

  • January 31, 2010 at 10:14 pm

    #1111418

    Hi Crazy, as u have told, i did that, restarted all services and everything, but the Service Type cannot be changed, its blank for Fulltext service. Wat to do, plz suggest..

  • February 2, 2010 at 10:38 am

    #1112415

    I had the same problem and this is how I fixed it.

    1. Make sure the Full text catalog service runs as on the same account as the sql server.

    2. Navigate to fulltext catalog on your database right click and rebuild the catalog.

    Hope this helps Good Luck.

    Brij.

  • February 2, 2010 at 6:41 pm

    #1112612

    Hi Crazy , I had tried everything, but surprisingly it started working. 🙂

    Hi Brij, I dont know, by hook or crook, I actually did what you told and know after reading your answer, I realized that I did exactly the right thing. Thats y it has started working. I hope it will continue to work for future.

    Thanks a lot, Guys for your help and hope to meet with you again for future queries.

    By the way, I am trying to do a DBA course in SQL server 2008. Can you suggest for a good institute in Bangalore. I m already working in a company, handling everything by hook or crook, but now i want to do a certification and work more and become master. Your suggestions are open. Thanks again.

    Regards,

    Arnab

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply