Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2005 - Repopulate Full Text Catalog After Migration Expand / Collapse
Author
Message
Posted Tuesday, September 25, 2007 10:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 25, 2007 2:18 AM
Points: 7, Visits: 29
Posted - 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.
Post #402645
Posted Tuesday, September 25, 2007 10:33 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, May 1, 2014 7:26 AM
Points: 908, Visits: 2,804
You have to check the status of the full text catalog.

Start with this one:
select * from sys.master_files where type = 4

also check out sys.fulltext_catalogs
Post #402657
Posted Tuesday, September 25, 2007 11:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:35 PM
Points: 12,887, Visits: 31,832
am 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 database
linky after editing:
http://support.microsoft.com/kb/240867

SUMMARY
Full-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.




Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #402687
Posted Tuesday, September 25, 2007 12:14 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, May 1, 2014 7:26 AM
Points: 908, Visits: 2,804
In 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.
Post #402692
Posted Tuesday, September 25, 2007 12:18 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:35 PM
Points: 12,887, Visits: 31,832
thank 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?


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #402695
Posted Tuesday, September 25, 2007 12:24 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, May 1, 2014 7:26 AM
Points: 908, Visits: 2,804
Yup. 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_name
FILE = 'sysft_fulltext_cat'
TO backup_device
Post #402700
Posted Wednesday, September 26, 2007 1:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 25, 2007 2:18 AM
Points: 7, Visits: 29
Thanks very much, i was able to populate Full Text Catalogs now. :)
Post #402880
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse