Geek Answers Handbook

SQL Server Storage FILESTREAM

If I have a SQL Server 2008 database that uses FILESTREAM and stores 10 terabytes of files. Should all files be in the same physical field (requires a server with more than 10 terabytes)? Or can I store 1 terabyte on one server, another terabyte on a second server and so on? From what I read, can you only store files on one server (remote or local)?

+4
source share
1 answer

Unfortunately, now it is limited only to local disks: - (

See this article in Simple-Talk: Introduction to FileStream SQL Server

At the end of the article there is a section FILESTREAM Constraints , which has one point:

* FILESTREAM data can be stored only on local disk volumes

From what I read, SAN (storage area network) could be used to store FILESTREAM, but not for other forms of storage systems. For 10 TByte, I would suggest that you plan on a SAN anyway, right?

Also see this other fooobar.com/questions/393923 / ... (and answers to it) on this topic.

+3
source

More articles:


All Articles