.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Abhijit
Post New Web Links

How to move the SQL Server SQLFT log files created by the full text catalog process.

Posted By:      Posted Date: November 04, 2010    Points: 0   Category :Sql Server
 

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. 

Thank you.

 


g


View Complete Post


More Related Resource Links

Moving full-text catalog from one server to another using backup / restore

  

Dear Sirs,
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:

use master
go

sp_detach_db 'SiteEng2004'
GO

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')
FOR ATTACH;
GO


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.


How to create a SSIS package to import records form SQl Server 2008 tables to text files

  
I am a newbie to SSIS and would like to create a package to accomplish the task referenced in the above title. Will appreciate any links and pointers in the right direction.   Thanksakoranteng

full text catalog size?

  
Is there a good way, using TSQL, to examine the size of a given full text catalog?   Does SQL compress the full text catalog?   SQL 2008 SP2   thanks  

SQL 2008 Full-Text-Catalog Population Schedule "Repopulate catalog" grayed-out (inactive)

  

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?

TIA,
Owen


Enable Full Text Index in VWD 2008 / SQL Server Express 2008

  

 Hi, I am using VWD 2008 Express and SQL Server 2008 Express. I want to enable full text index in some of my table. How do I do that? I only have  SQL Server Management Studio Express 2008. As far as I know, I cannot use SQL Server Management Studio Express 2008 to update the full text catalog according to : http://msdn.microsoft.com/en-us/library/ms365247.aspx

My tables are also not enable Full Text Search by default. 

 

 Any help would be very much appreciated!


 Edit 1: Someone had a similar problem to mine on this link: http://forums.asp.net/t/1169961.aspx
I installed the Sql Server 2008 Express with Advance Services and made sure that Full Text functionality is installed. However I don't get a full text menu in SQL Server Management Studio. 

 Edit 2: I uninstall and reinstall SQL Server 2008 Express with Advance Services but still couldn't be able to enable full text index.

 Edit 3: After see this, I guess I have to do it manually then:  http://forums.microsoft.com/MSDN/ShowPost.aspx?siteid=1&PostID=3912985


Can't full text search pdf files

  

I have a MyDocuments table that has the following columns: ID, Document varchar(max), and DocumentType

I'm only able to get HTML and TXT results from my full text search queries -- but I know that I should be getting PDFs as well.

What am I doing wrong?

FYI: I did install the iFilter.


Does all SP 2010 Databases needs to be created with Full text Indexing?

  

Hi All,

Can anyone please tell me if all the SP 2010 databases (including configurations DB, content DB and service DBs) needs to be created with Full Text Indexing in SQL?

If my understanding is correct, I feel only the Content DB is required to be created with Full text Indexing.

But, I need experts comments on this. :-)

Regards,
Jagan


Many Missing Column Statistics errors on full-text index fragments, even after reorganizing catalog

  

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 sys . 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

How do I view Full-text search catalogs in SQL Server 2008 Express?

  
Hi,

I've installed SQL Server 2008 express with advanced services on my Vista Home Premium, and have enabled Full-text search. 

"SELECT fulltextserviceproperty('IsFulltextInstalled');" returns 1, and using CREATE FULLTEXT CATALOG mycatalog I was able to create my Full-text search catalog. I was then able to create full-text indexes on my DB columns, and even search through them.

However, there is no &

Conversion of text files from ANSI to UTF-8

  
reading and writing text files in ANSI format and
writing html-files in Charset ISO-8859-1 (Western Europe).

dynamically adding sql server columns based on number of files in fileuploader

  

I want to create a new table to sql database at runtime.  The column names would be "Name", "Date", "Event".  I would also like to have one more column name "Image" but the problem is that since the amount of images will vary, I want the application to count the amount of files in the Multiple fileuploader and then add a image column to the table for the respected amount of files. 

For example if i am uploading 3 files in the multiple fileuploader, the names should be "Name", "Date", "Event", "Image1", "image2", Image3"

I also would like that table name to be name dynamically from the textbox Name when the user enters the information.

 

I have the following code to make a new table, but I dont know how to name the fields at runtime like previously asked please help!!!

 

Dim objConn As New SqlConnection("Server=<servername>;uid=<userid>;pwd=<password>;database=master")

objConn.Open()

connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.

  

I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

 I have two SQL Server instances installed.

 1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?


CI Server: Redefine Your Build Process with Continuous Integration

  

Jay Flowers demonstrates how to set up and use a Continuous Integration server using both discrete tools and the more comprehensive CI Factory solution.

Jay Flowers

MSDN Magazine March 2008


Copying files to a folder on web server

  

Hi

I have few files in FolderA on the web server.

I want the users to select a fews files from FolderA and copy them to FolderB on the same web server.

I want to list all the files in FolderA and allow the user to select a few files and copy.

I want to copy the files programatically when the user selects a few files and click on Copy button.

How to copy the files quickly from folderA to FolderB?

thanks

Ashok

 


Full text search in a Word document

  

Hello,

  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,


Lam

 


The file reached the maximum download limit. Check that the full text of the document can be meaning

  

Hi,

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

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend