SQL Server Express 数据库大小/BLOB 存储

本文介绍了SQL Server Express 数据库大小/BLOB 存储的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在阅读有关 SQL Server 中的外部 blob 存储的信息，并想知道这与数据库大小有何关系.在谈论 SQL Server Express 时，您对数据库大小有限制(我相信 2008 年为 10GB).那么您的 ESB 存储呢?这是考虑到这个限制，还是只计算实际的 .mdf 文件本身?想一想，.ldf 日志文件呢?

我正在考虑与 SharePoint 相关的问题.由于内容数据库的主要部分通常由较大的 blob 对象(文档)组成，因此如果可以节省全尺寸 SQL Server 许可，将它们移至 ESB 可能非常划算.

更新: 在此处发布有关 SharePoint Foundation - SQL Express 的可能节省选项的信息:​​blog.repsaj.nl/index.php/2012/09/sp2010-saving-yourself-a-full-sql-许可证/

解决方案

10gb 大小限制仅涉及 .mdf - 对 .ldf 没有限制.

此外，在 SQL Server 2008 中 - 数据库大小限制不适用于在数据库中存储为 FILESTREAM 的数据(请参阅 FILESTREAM 兼容性:SQL Server Express 支持 FILESTREAM.10 GB 数据库大小限制不包括 FILESTREAM数据容器).

I was reading about external blob storage in SQL Server and was wondering how this relates to the database size. When talking SQL Server Express, you have a limit in database size (for 2008 it's 10GB I believe). So how about your ESB storage? Is that taken into account for this limit, or does it only count the actual .mdf file itself? Thinking about it, what about the .ldf log file?

I was thinking about this related to SharePoint. Since the major part of a content database usually consists of larger blob objects (documents), it could be very cost effective to move those to ESB if that saves you fullsize SQL Server licenses.

Update: Posted about a possible savings option for SharePoint Foundation - SQL Express here: blog.repsaj.nl/index.php/2012/09/sp2010-saving-yourself-a-full-sql-license/

解决方案

The 10gb size limit concerns the .mdf only - no limit on the .ldf.

Also, in SQL Server 2008 - the database size limit does not apply to data stored as FILESTREAM in your database (see FILESTREAM compatibility: SQL Server Express supports FILESTREAM. The 10-GB database size limit does not include the FILESTREAM data container).