Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
Full text indexing issue
March 18, 2011
One of our application uses around 325 databases.
These databases are hosted in one Sql Server Instance and we use Sql Server 2008 R2.
One of the feature of the application is Full Text Searching and for this we use the Full Text Search feature of Sql Server 2008.
For all the databases, we have given the option "Manual" and every night (after 11:00 PM) we run the full text indexing from one of our service.
Recently we found that there are about 400,000 of the crawl logs in the %ProgramFiles%\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\LOG directory. I have been removing the older ones (it was in the millions) and still there are this many files.
Also, when the Sql Server Instance is restarted, it starts creating these files again and it takes the whole day for all these databases to come back live.
What are we missing here. Can we stop the creation of these log files or can we remove old files that are created.
Due to these files, the memory consumption of the server on startup of the instance is also huge. Could anyone please advice us what to do.
Thanks a lot in advance...
Posted Date: March 18, 2011 Points: 20
You can follow these series of articles
Hope this helps
Hope this helps.
Thanks & Regards,
To post reply
Related Questions Related Questions
Sql Server 2008 R2 - Removing Full Text Index Crawl Logs
How to write to a text file in C#
security issue in web services
User can not select TEXT for copy paste from my .aspx page...
How to show hyperlink, Linkbutton text on the tiltle bar of Internet explorer...
How to restrict user to (ctrl+v) option for a text box..?
display text in other page using c#
display text in other page
disply contacts in text box seperated by cama
ASP.NET web application - WebResource.axd and ScriptResource.axd files - Loading time issue
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend