Solved

Limit of saving file in sql table

Posted on 2013-02-03
7
149 Views
Last Modified: 2013-02-03
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?
0
Comment
Question by:Camillia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 9

Expert Comment

by:Aeriden
ID: 38849041
0
 
LVL 9

Accepted Solution

by:
Aeriden earned 250 total points
ID: 38849043
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
 
LVL 7

Author Comment

by:Camillia
ID: 38849060
If i want to think in terms of pages, how many pages is 2GB? or i cant compare it as such?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 9

Expert Comment

by:Aeriden
ID: 38849268
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
 
LVL 7

Author Comment

by:Camillia
ID: 38849275
I want to explain to my manager what 2GB compares to # of PDF files.
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 250 total points
ID: 38849617
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
 
LVL 7

Author Comment

by:Camillia
ID: 38849669
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

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
TSQL recursive CTE challenge... 8 48
Negative isnull? 3 32
Can a Trigger trigger a Trigger? 4 47
SQL 2008 - Disappearing Temp Table in Stored Procedure 24 64
Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question