What is the limit for saving images in SQL server 2008 r2 database?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

I'm thinking in design a form as prescription, feed it with the data, then capture it and print, and save captured image in the database as image.
But i'm afraid of database growth when i save every prescription as image in it(after years) database reach a size limit,
Is that right to save the prescriptions by this way? or there is a better way to save the prescription to retrieve and print it at any time.

What I have tried:

Is that better to save the prescription content as seperated strings in one cell(separated by any sign like ($$)), when user try to retrieve a prescription the program seperate the cell content (make every $$ a new line) and draw them to the form to print?

Posted 16-Feb-17 2:26am

XRushdy

Updated 16-Feb-17 5:34am

v3

Add a Solution

Comments

[no name] 16-Feb-17 9:16am

"Is that right to save the prescriptions by this way", last I heard, best practice was to save files to the file system and a path to the file in the database.

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)

Richard Deeming · Answer 1 · 2017-02-16T05:34:00

SQL Server has a theoretical maximum database size of 524272TB.
Maximum Capacity Specifications for SQL Server[^]

Obviously, a database cannot be larger than your available storage capacity, which will almost certainly be several orders of magnitude lower.

If you're using the Express edition, each database is further limited to 10GB of data. (This does not include FILESTREAM[^] data or log files.)

As mentioned in the comments, the best approach remains to store files in the file system. But if the output is simple enough to recreate, storing the raw data needed to recreate it in the database would also work.