Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Full Text Catalog

Status
Not open for further replies.
ericarivera411

ericarivera411

IS-IT--Management
May 5, 2006
50
US
I have a full text catalog in Microsoft's SQL Server 2000, with Server 2000, and the catalog is taking for ever to build. We are talking DAYS. Right now its only on 3,000 objects when the database holds well over 10,000. At this rate it should finish this week... Is there anything I can do to speed this process up? That server also does the backup's for the company. Is it possible that the backups are slowing down this process???
Any help would be appreciated. Thanks!
Erica
 
Sort by date Sort by votes
The amount of time that it takes to create the full text index will depend on how much data is in each record, how many records, how fast the drives are, and how much the drives are being used.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Adding Text to and XML Field 1
Replies
2
Views
173
grnzbra
grnzbra
Cpreston
  • Locked
  • Question
Update another column if text in another exists 2
Replies
4
Views
138
Cpreston
Cpreston
bmacbmac
  • Locked
  • Question
How to import plain text from Word doc to SQL 1
Replies
4
Views
236
Chris Miller
Chris Miller
lameid
  • Locked
  • Question
TSQL Text Import
Replies
3
Views
117
lameid
lameid
BigDave619
  • Locked
  • Question
NZ(DLookup) changed from "Number" field to "Text" field 1
Replies
4
Views
110
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top