October 3, 2012 at 9:56 am
Hello - I would like to get some info on storing BLOBs within a database - not FILESTREAM.
I am currently using SQl Server 2008 Standard and I have a client that wants to store files within the database as BLOBS.
I haven't gotten a straight answer from the client on file size - so far it is between 10kb and "much larger than 1MB".
The vendor is recomending against using BLOB because of the potential file size and also because of the changes and testing needed to their website and report application. The database current size is 75 gb.
The client came up with the idea of storing data in the database when they were unable to use an SFTP server to make the reports available.
What I need are some concrete facts on the effects of storing BLOBs in SQL Server 2008 (Most of what I find talks about FILESTREAM)
Are there no concerns as far as performance? How does storage work with BLOBS? Does storing a 1MB file equal 1MB to the database size?
Could anyone offer offer advice or good links to check out - I'm looking for myself but not finding what I need.
Thanks
Dave
October 3, 2012 at 2:48 pm
You do not have to turn FILESTREAM on in order to store BLOB files in SQL 2008/R2 unless the files you want to store are larger than 2GB.
When I researched this just before the release of SQL 2008 R2, the maximum size of binary data/BLOBS was 2GB using VARBINARY(MAX). If you turn FILESTREAM on then you can store BLOBS larger than 2GB. FILESTREAM is not required.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply