CODEWITHSUNDEEP
sqlsql-serversql-server-2008filestream
Jack
Jack

Reputation: 7557

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.

Upvotes: 1

Views: 632

Answers (2)

jacanstar
jacanstar

Reputation: 1

No it does not increase the size of the database as the files are not stored in the Database. Please read the following "FILESTREAM Design and Implementation Considerations" --google is your best friend

Upvotes: 0

MarkD
MarkD

Reputation: 5316

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.

Upvotes: 1

Related Questions