CODEWITHSUNDEEP
indexingfull-text-searchsql-server-2012
Fabio
Fabio

Reputation: 545

Full-Text indexing with SQL Server 2012 without storing the files

I was wondering, is it possible to use the Full-Text search of SQL Server 2012 without storing the documents in the database? I know that there are several services that offer file indexing without then storing your files, but only the indexed data; is it possible to use SQL Server 2012 that way?

Fabio.

Upvotes: 2

Views: 826

Answers (1)

aks
aks

Reputation: 25377

No. As of today, the full-text index is dynamically modified based on the table contents. So if you were to delete the rows holding the data the index will be updated to reflect the changed table.

I am assuming that you have looked at solutions like Filestream to store unstructured data on the file system and are instead looking at getting rid of the indexed documents entirely.

Upvotes: 3

Related Questions