Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Other SQL Server 2008 Topics  Filestream and Full Text Search with Express

Author  Topic  rdagger Starting Member 1 Post Posted - 2009-03-09 : 17:22:29 I have a SQL Server 2008 Express database that has about 1 GB of data. I have an additional 3 GB of text files that I want to make full text searchable. In order to avoid the 4 GB Express limit we have been using Lucene for the text files. I am considering dropping Lucene and adding the text files to the SQL database using Filestream. Does the size of the Filestream files contribute to the 4 GB limit? Approximately, how big would the FTS indexes be for 3 GB of text files and do these indexes contribute to the 4 GB limit?