Storing PDF files as binary in sqlserver

Question

0.00/5 (No votes)

See more:

SQL-Server-2016

, +

Now I am considering options to store the documents on the server
I'll have PDF documents mostly around 1 Million or so,those will store into a SQL Server table
I am aware that I will reach the 8TB, I'm not sure about limit .mdf size of SQL Server Enterprise edition.
After the PDF files are stored they can be downloaded and viewed via browser after entering the related order number.
Here is some additional information:
-The PDF files will have a size of around 1-2 MB. each
-SQLServer 2016 Enterprise
-2TB SSD*4

What I have tried:

my table of orders by a varbinary(MAX) column and store the PDF document directly into that binary field.

Posted 12-Nov-18 1:59am

terzasek

Updated 12-Nov-18 2:04am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2018-11-12T02:04:00

Don't store them in SQL server - store them as files (I'd use a GUID as the file name) and store the location plus the original filename in SQL.
That way, you aren't clogging SQL with unnecessary data, using up huge amounts of SQL server bandwidth, and you make it easier to back up the whole system.

As long as all the apps that would fetch them from the DB have access to the folder, it's all a lot simpler.