开发者

How to manage huge amount of data using filestream since only local paths are supported for data storage?

开发者 https://www.devze.com 2023-01-07 11:05 出处:网络
As pointed out in this question when using filestream with sql server 2008 the data must be stored locally.

As pointed out in this question when using filestream with sql server 2008 the data must be stored locally. This means that I cannot use

\\FILESERVER\FileStreamData\MyDatabase

for Filestream filegroup path.

So if I need t开发者_运维技巧o use filesrteam and have lots of data, is buying a very large hard drive the only solution (this could be quite limiting in many scenarios)? It is not possible to use a NAS? Typically one installs SQL Server on a perofrming machine but keeps the large documents in a NAS or anyway on some fileserver. With filestream this is not possible, so how to do it?


Note that you can partition your FILESTREAM table to distribute the FILESTREAM data across multiple disks.

Regarding NAS, see this article by Bob Beauchemin where he says "Note that the filegroup needs to point to a local file system location; filestreams can't live on a remote server or a network addressable storage (NAS) devices unless the NAS device is presented as a local NFS volume via iSCSI."

It indicates that if the NAS device is presented as a local volume via iSCSI, it can be used to store FILESTREAM data. (I have not tried this though)

0

精彩评论

暂无评论...
验证码 换一张
取 消