Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 SQL Server 2005 - FTS - Repopulate After Migration

Author  Topic 

Sameer100
Starting Member

3 Posts

Posted - 2007-09-25 : 11:12:47
I have Restored database from SQL server 2000 to SQL server 2005 and found that Full Text catalogs are not Populated.

I tried using, exec sp_fulltext_catalog 'CatalogName', 'start_full' and it showed the message
"Warning: Request to start a full-text index population on table or indexed view 'dbo.Corpora' is ignored because a population is currently active for this table or indexed view."

Please let me know on "How to Repopulate all the Full text catalogs"

Thanks.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-25 : 23:17:12
Right click on catalog and choose properties in ssms, you can set population schedule there.
Go to Top of Page
   

- Advertisement -