Click here to Skip to main content
13,624,686 members
Rate this:
Please Sign up or sign in to vote.
See more:
In A project Needed to save the scanned image. Please guide Me What volume of files Can stored in Sql Server database(2005 AND 2008) That not lower speed OR You Have better suggestion?
Posted 16-Dec-13 9:30am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

It's pretty hugs, but it depends on which version of SQL Server you have - the Express version for example is generally restricted.
The "Normal" limits are here:[^] - there is a drop down for the different versions 2008R2 / 2008 / 2005 will start to use server bandwidth pretty quickly if you aren't careful, which can slow things down a lot - I'd be tempted to keep them as files in a suitable HDD and store the path to the image in the DB instead. That also makes it easier to do regular (non SQL) backups, as you don't need to copy a single multi-terabyte file...
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

There are a lot of discussions regarding whether storing BLOB Data in the Database or in file system. You can check the links below, learn the advantages/disadvantages and see which way works better for you.[^][^]

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Cookies | Terms of Service
Web04-2016 | 2.8.180712.1 | Last Updated 23 Dec 2013
Copyright © CodeProject, 1999-2018
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100