Jack Jack - 7 months ago 46
SQL Question

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.


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.