Search code examples
sqlsql-serversql-server-2008filestream

Will using FileStream in SQL Server increase database size?


I am using AppHarbor for hosting my website and currently it offers only 20MB free space. I want to store PDF files using SQL Server's FileStream column. Would using FileStream increase the database size because FileStream basically stores on hard disk as I know.

Any help would be appreciated.


Solution

  • Because the FILESTREAM data becomes part of the database, in the sense that it has its own FILEGROUP(s) and can (should be) be backed up through SQL backups - I would answer yes.