Since two months, our SharePoint 2010 (on SQL 2008R2 std) intranet is live on production. Step by step, we add more features and content, migrating one department every 3 months into it. Next department is marketing and the specification includes the integration of a picture database of 12GB as well as storing videos and other high volume files. Therefore, we thought of implementing BLOB storage.
Our partner asks us to chose between RBS and some external add-on like Docave or AvePoint.
Our internal SQL team has not that much experience with SQL yet and prefer keeping administration as simple as possible (for backup procedures especially).
Based on what I have read and heard (including a prosentation from MS MVP at the TechDays of Paris in February 2011), I would prefer going with RBS for the following reasons:
- Filestream provider is included in SQL;
- Backup management is integrated in SQL (as see at techDays)ion);
- We do not need compression or encryption;
- As RBS is built-in, the IT team will not need to learn one more tool.
When about to start implementing RBS, our partner echoed us some interrogations about selecting RBS over an add-on:
- RBS would not support a cluster configuration (but during the TechDays, I saw that clustering was supported by RBS while mirroring was not);
- Blobs are saved on a local file system and not on a SAN (but on this article I read that blobs can only be saved on the same location than the content DB, which, in our case, means on our SAN).
SharePoint 2010 enterprise on 5 servers + SQL cluster:
- 2 web front-ends
- 3 application servers
- SQL cluster (2 servers) with SQL standard 2008 R2
- A SAN bay from 3PAR (HP) to store the content DB. The SAN is seen as a local partition by the servers0
So, is there any reason not to use RBS ?
EDIT on 30/3/2011: Microsoft Support Premier confirmed the following:
- Clustering is indeed supported.
- The storage area must be located at the same location than the content database.
We're starting with RBS on 11/4/2011 on our dev environment and I will keep you posted.
EDIT on 21/6/2012: We are using RBS since a year now in production and it works like a charm. So yes, RBS is a solution.