InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 10:12:33 GMT20http://www.sqlservercentral.com/Forums/Topic402645-149-1.aspxThanks very much, i was able to populate Full Text Catalogs now. :)Wed, 26 Sep 2007 01:18:03 GMTkprabhakar1978http://www.sqlservercentral.com/Forums/Topic402645-149-1.aspxYup. But verification of status / file location / etc. is the first step.Regarding the backup / restore note that there is also a command to backup and/or restore the full text catalog only.BACKUP DATABASE database_nameFILE = 'sysft_fulltext_cat'TO backup_deviceTue, 25 Sep 2007 12:24:17 GMTPam Brisjarhttp://www.sqlservercentral.com/Forums/Topic402645-149-1.aspxthank you Pam!I didn't know they did that in 2005. much easier to restore I assume, since it's part of the backup.In the original posters case, since the backup came from a 2000 backup, he'll need to rebuild no matter what, adn backup after they are rebuilt, right?Tue, 25 Sep 2007 12:18:23 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic402645-149-1.aspxIn SQL Server 2000 full text catalogs are indeed not backed up. However, information about the file location, tables and indexes remain in the database.With SQL Server 2005, full-text catalogs have become part of the standard backup/restore process.Tue, 25 Sep 2007 12:14:26 GMTPam Brisjarhttp://www.sqlservercentral.com/Forums/Topic402645-149-1.aspxam i wrong? i thought full text catalogs were not part of the database, but a separate file stored on the server, so you needed to back those up separetely, or recreate the full text after a restoration on a different server/different databaselinky after editing:http://support.microsoft.com/kb/240867[i]SUMMARYFull-text catalogs and indexes are not stored in a SQL Server database. Full-text catalogs and indexes are stored in separate files that the Microsoft Search service manages. The full-text catalog files are not recovered during a Microsoft SQL Server recovery. Additionally, you cannot use the Transact SQL statements BACKUP and RESTORE to back up and to restore full-text catalog files. After recovery or restore operations, you must separately resynchronize the full-text catalogs. Only the Microsoft Windows NT system administrator and the Microsoft Search service can access the full-text catalog files.[/i]Tue, 25 Sep 2007 11:52:31 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic402645-149-1.aspxYou have to check the status of the full text catalog.Start with this one:select * from sys.master_files where type = 4also check out sys.fulltext_catalogsTue, 25 Sep 2007 10:33:28 GMTPam Brisjarhttp://www.sqlservercentral.com/Forums/Topic402645-149-1.aspxPosted - 09/25/2007 : 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. Tue, 25 Sep 2007 10:07:02 GMTkprabhakar1978