SharePoint Foundation 2010 RBS FILESTREAM 迁移
我们安装了带有大型内容数据库 (~30 GB) 的 SharePoint Foundation 2010，并且已将 SQL Server (2008 R2) 和 SharePoint 配置为使用 FILESTREAM RBS。我对 FILESTREAM RBS 的理解是它应该将 BLOB 与 mdf 文件分开存储在磁盘上。 事实上，我已经尝试将新文档导入到文档库，并将它们存储在指定的磁盘位置，我可以验证这些是我上传到 SharePoint 文档库的文件。
我们还需要将现有数据从数据库迁移到 RBS FILESTREAM 存储。据推测，这是通过 powershell 为给定内容数据库调用名为 migrate 的 SharePoint API 方法来实现的，如 这篇 Technet 文章。
我昨天下午开始迁移，过了一会儿，今天该过程已完成，但在配置过程中指定的约 35 GB 的 Blob 数据中，BlobStorage 文件夹的大小仅为 250 MB。另一方面，内容数据库中有大约 6 个 mssqlrbs_filestream_data_n 表。每个 5 GB。数据库的可用空间与以前相同，mdf 文件大小相同，并且包含 mdf 和 ldf 文件的目录中没有其他文件，因此看起来数据已在表之间移动但尚未迁移正如我所料，到 BlobStorage 文件夹。
我对 FILESTREM RBS 存储或 SharePoint blob 数据迁移过程肯定有一些误解。
是否需要执行额外步骤将数据从 mssqlrbs_filestream_n 表移至磁盘？
We have a SharePoint Foundation 2010 installation with a large content database ( ~30 GB ) and we have configured the SQL Server (2008 R2) and the SharePoint to use FILESTREAM RBS. My understanding of FILESTREAM RBS is that it should store the BLOBs on disk separately from the mdf file.
Indeed I have tried importing new documents to document libraries and it stores them in the specified disk location and I can verify that these are the files I have uploaded to the document library in SharePoint.
We also need to migrate the existing data from the database to the RBS FILESTREAM storage. Presumably this is achieved through powershell calling a SharePoint API method called migrate for a given content database as described in this technet article.
I started this migration yesterday afternoon and after a while today the process has finished but of the ~35 GB of blob data the BlobStorage folder which I have specified during the configuration is only 250 MB in size. On the other hand there's 6 mssqlrbs_filestream_data_n tables in the content database approx. 5 GB each. The database has the same about of free space as before, the mdf file is the same in size and there's no additional files in the directory with the mdf and ldf files so it looks like the data has been moved between tabled but have not been migrated to the BlobStorage folder as I expected.
There must be some misconception I have about the FILESTREM RBS storage or about the SharePoint blob data migration process.
Is there an additional step to move the data from the mssqlrbs_filestream_n tables to disk?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您传输的文件有多大？听起来其中大多数都低于内联存储的默认 61140 字节限制，因此存储在内部表中的 varbinary(max) 列中，而不是 Filestream 列中。
这个 RBS 博客文章 对这些值进行了详细解释。我们已经进行了大量的性能测试，以确保它们针对 Filestream 功能进行了优化，但如果您有将这些文档的存储卸载到 Filestream 的特定需要，则可以为任何新插入的 blob 更改这些值。您可以在内容数据库的 mssqlrbs.rbs_blob_stores 视图中查看这些配置值（max_size_inline_blob、max_size_inband_write 和 max_size_inband_read）的当前值。
How large are the files you transferred? It sounds like the majority of these are under the default 61140 byte limit for inline storage so get stored in varbinary(max) columns in the internal tables rather than the Filestream column.
This RBS blog post has a detailed explanation of these values. We’ve done a lot of performance testing to make sure they’re optimized for the Filestream feature, but if you have a specific need to offload storage of these docs to Filestream it's possible to change these values for any new inserted blobs. You can see the current values of these configuration values (max_size_inline_blob, max_size_inband_write and max_size_inband_read) in the mssqlrbs.rbs_blob_stores view in your content database.