什么数量的文件可以存储在Sql Server数据库中 [英] What volume of files Can stored in Sql Server database

问题描述

在项目中需要保存扫描图像。请指导我可以存储在Sql Server数据库中的文件量是多少（2005年和2008年）那不低速或者你有更好的建议吗？

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?

推荐答案

这是非常拥抱，但是这取决于您拥有的SQL Server版本 - 例如Express版本通常受到限制。

正常限制在此处：http://technet.microsoft.com/en-us/library/ms143432(v=sql.105).aspx [ ^ ] - 2008R2 / 2008/2005的不同版本有一个下拉菜单



但是......如果你不小心的话，你会很快开始使用服务器带宽，这可以减慢很多事情 - 我很想把它们作为文件存放在合适的硬盘驱动器中，而是存储数据库中的图像路径。这也使得更容易进行常规（非SQL）备份，因为您不需要复制单个多TB文件...

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: http://technet.microsoft.com/en-us/library/ms143432(v=sql.105).aspx[^] - there is a drop down for the different versions 2008R2 / 2008 / 2005

But...you 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...

关于是否有很多讨论将BLOB数据存储在数据库或文件系统中。你可以查看下面的链接，了解优点/缺点，看看哪种方式更适合你。



http://forums.asp.net/t/1096999.aspx [ ^ ]

http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay [ ^ ]

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.

http://forums.asp.net/t/1096999.aspx[^]
http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay[^]

这篇关于什么数量的文件可以存储在Sql Server数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！