Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm working in a company that currently develops Media Asset Management system and now we want to improve our system for document files. I have to search nearly thousand .doc and .pdf files and index them.

I want to use SQL Server's filestream and full-text search capabilities for this job but my colleagues warn me about accessibility and database size. When you use SQL Server, it saves document files in its share and change the file name so database file size is getting bigger and bigger.

They offered me to use Windows Search Service. In this way, indexing and storing is not my job so my database will be clean and accessing files are relatively easy.

I'm confused. Which way do I prefer or is there any other way?

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.