You are designing a SharePoint 2010 application to store 50 GB of digital assets, including audio and video files
that are up to 20 MB in size. You have the following requirements:
The disk storage system must use standard hard drives and must be configured to optimize read performance.
.The SharePoint 2010 database uses Microsoft SQL Server Express 2008.
.The application must leverage standard SharePoint 2010 components to limit the requirement for custom development.
You need to design a storage solution that meets all of these requirements.
Which approach should you recommend?
A.
Enable FILESTREAM storage for a Microsoft SQL Server Express 2008 database on a RAID 0 disk system.
Then install and configure remote Binary Large Object (BLOB) storage in SharePoint 2010.
B.
Store the assets directly in Microsoft SQL Server Express 2008 and create multiple content databases on a RAID 0 disk system.
C.
Install and configure support for external BLOB storage for SharePoint 2010 and use the ISPExternalBinaryProvider interface to manage files on a RAID 0 disk system.
D.
Install and configure support for external BLOB storage for SharePoint 2010 and configure a Microsoft SQL Server Express 2008 database to store BLOBs on a RAID 5 disk system.
http://blogs.technet.com/b/wbaer/archive/2011/02/22/filestream-and-sharepoint-2010.aspx
http://technet.microsoft.com/en-us/library/ee748607(v=office.14).aspx
The SQL FILESTREAM provider is a feature of SQL Server 2008 Express that enables storage of and efficient access to BLOB data by using a combination of SQL Server 2008 Express and the NTFS file system.
Local RBS provider
A local provider stores the BLOBS outside the database but on the same server that is running SQL Server. You can conserve resources by using the local RBS FILESTREAM provider to put the extracted BLOB data on a different (that is, less resource-intensive) local disk. Because the BLOBs are stored in the same Filegroup as the metadata, SharePoint Server 2010 features, such as backup and restore in Central Administration, can be used.
The RBS FILESTREAM provider is available through the SQL Server Remote BLOB Store installation package from the Feature Pack for Microsoft SQL Server 2008 R2. The RBS FILESTREAM provider uses the SQL Server FILESTREAM feature to store BLOBs in an additional resource that is attached to the same database and stored locally on the server. The FILESTREAM feature manages BLOBs in an SQL database by using the underlying NTFS file system.