View Complete Post
We've recently upgraded our server from SQL 2000 to SQL 2008 and we're having a problem scheduling the recurring repopulation of our full-text search catalogs.
Under the "General" page of the "Full-Text Catalog Properties" window, the "Repopulate catalog" radio button is disabled (grayed out).
Under the "Population Schedule" page of the "Full-Text Catalog Properties" window, the "Population Type" dropdown contains ONLY "Catalog - optimze". How do we schedule the full-text catalog repopulation? What setting are we missing?
I'm having a problem with Full-Text Catalog in SQL SERVER 2005.
The problem is: I did a backup of a database that has a full-text catalog from one server and restored on another server.
The restore worked perfectly, but the catalog is down because it is pointing to the physical path from the source server.
To recover this full-text catalog I tried the commands below:
CREATE DATABASE SiteEng2004 ON
(FILENAME = 'D:\SQL SERVER\DADOS\SiteEng2004\SiteEng2004_Data.MDF'),
(FILENAME = 'E:\SQL SERVER\LOGS\SiteEng2004\SiteEng2004_Log.LDF'),
(FILENAME = 'D:\SQL SERVER\DADOS\SiteEng2004\IDX_CATALOG')
Unfortunately it did not work and the following error message occurs :
Msg 5120, Level 16, State 101, Line 2
Unable to open the physical file "D:\SQL SERVER\DADOS\SiteEng2004". Operating system error 5: "5(error not found)".
Could anyone help me on what I should do to restore this full-text catalog on the destination server ?
Thanks in advance.
I seem to have a large number of full-text index fragments, even after reorganizing both full-text catalogs. (SQL 2008)
While reviewing the results of the default trace, I noticed many “Missing Column Statistics” errors.
Seeing as how there are over a thousand of these errors within a 12 hour period, I figure this is something I should take care of.
From trace, text data column:
NO STATS:([MyDBName].[sys].[ifts_comp_fragment_2014778570_51269].[colid], [MyDBName].[sys].[ifts_comp_fragment_2014778570_51269].[pid], [MyDBName].[sys].[ifts_comp_fragment_2014778570_51269].[docidmax], [MyDBName].[sys].[ifts_comp_fragment_2014778570_51269].[dupseq])
When I query
fulltext_index_fragments , I see about 15 different fragments for each catalog, all with a status of 4.
I expected to see many more fragments listed, with a status of 0 maybe?
I guess I’m misunderstanding something.
After reorganizing the catalogs, I’m still seeing these
I need to move the location of the SQLFT text log files from it's current location %ProgramFiles%\Microsoft
SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\LOG folder to another larger drive to accomodate the log file growth. I cannot find anything on how to make this change. Does anyone have an answer? I have found this is a default at
install - but during install did not find how to change this.
ÃÂ IÃÂ´m currently programming a web search application in ASP.Net and having problem with full text searching. My requirements are:
1. Save a byte array from SQL server to word document as a temp file in a server side?
2. How to highlight the string I am currently searching in the Word document and return to the user the sentence with the highlighted string (like on Bing or any other search engines)? Is it possible to fullfill this requirement with full-text search integrated in SQL Server 2008?
Thanks in advance,Regards,
I'm facing an issue with the indexing.
I have 1 WFE+Index server+DB server.
Index server is not installed with MS FIlter pack 1.0
When crawling, the there will be document with warning in crawl log:
The file reached the maximum download limit. Check that the full text of the document can be meaningfully crawled.
Documents that with warning are such as doc, ppt, xls, docs, ppts and many others.
However, I view into the successful crawled document, there are doucments with ext doc and ppt.
For large file index, there are MaxGrowthFactor + MaxDownLoadSize required to be added into the index server.
As my understanding is, MS Filter Pack should installed into index server(already did, correct me if i'm wrong).
I looked into the Office SharePoint Seach(CA>Services in farm), if the server is appointed to "Use this server as indexing server", then MS Filter Pack is suppose to be installed into that particular server as well.
At the bottom, there also has another option is "Use all web front end for crawling".
The question here is, IF the option "Use all web front end for crawling" is selected.
Does the WED FRONT END Server required to installed the Ms Filte
I have created procedure for full-text search and it works in SQL Management Studio 2008 (SQL Server 2008 Express) but in Visual Studio 2010 not - I have error:
Full-Text Search is not installed, or a full-text component cannot be loaded.
I have read somewhere that only admin can use full-text indexes - so how I can use full-text search in VS2010 ?