Limit of saving file in sql table

I dont want to use SQl Server's filestream. I want to save the files in a table in database using varbinary(max)....

How big the file can be?
LVL 7
CamilliaAsked:
Who is Participating?
 
AeridenConnect With a Mentor Commented:
Sorry, the link is for SQL 2012.  For SQL 2008, reference http://msdn.microsoft.com/en-us/library/ms188362%28v=sql.100%29.aspx

(still the same maximum size)
0
 
AeridenCommented:
0
 
CamilliaAuthor Commented:
If i want to think in terms of pages, how many pages is 2GB? or i cant compare it as such?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
AeridenCommented:
In the old days (circa SQL Server 4.x and 6.x) we used to think in terms of pages.  I haven't thought that way in a long time (haven't needed to).  Perhaps you could provide some insight as to why pages would be of concern to you (and perhaps relevant)?
0
 
CamilliaAuthor Commented:
I want to explain to my manager what 2GB compares to # of PDF files.
0
 
Anthony PerkinsConnect With a Mentor Commented:
I want to explain to my manager what 2GB compares to # of PDF files.
Unfortunately, you cannot do that.  The best you can do is pick some random files and divide the sum of all the sizes by the total number of pages.  For example the PDF that I see are a little over 2Kb per page, but I am talking about a PDF with over half a million pages.

But I do need to add that if you have PDFs with anywhere close to 2 GB and you are attempting to save in database you have bigger problems.

Good luck with your approach and make sure to come back to this thread in say about a year or two and tell us how it worked out for you.
0
 
CamilliaAuthor Commented:
Thanks. Not going to store 2GB of files. I was just looking at example. Going to put a limit on the size of the file we save.
0
All Courses

From novice to tech pro — start learning today.