We currently have a SharePoint 2010 farm running on top of SQL Server 2008 R2 Standard Edition, and would like to externalize our blobs. We have SMSP licenses, and all the databases and stores are on NetApp storage.
As far as I know, the SMSP RBS provider will require us to move to SQL Enterprise Edition, so it is out of the question.
What I would like to ask is the following:
- Is there any way to make SMSP RBS work with SQL Standard?
- Will SMSP backups work with the Microsoft FILESTREAM provider? Is there something special I have to do to make backups of the blob store? Will SMSP backups automatically create snaps of it?
- Does SMSP EBS works with SQL Standard Edition?
- What should be better: Microsoft Filestream RBS or SMSP EBS?
EBS is a SharePoint API so you can use this with SQL Standard Edition.
SP 2010 does support the use of EBS.
The SMSP EBS/RBS provider works with EBS. In the SMSP Storage Optimization, you select the use of EBS instead of RBS.
From a performance perspective, Microsoft FILESTREAM RBS and SMSP EBS is about the same. FILESTREAM performance is marginally better performing. However, the actual performance will depend on your environment.
From an operational perspective, I would recommend SMSP EBS as you can manage the externalization of SP content from within SMSP. With EBS, you can set more granular externalization policies.
With FILESTREAM RBS, you need to ensure that the SQL layout is correct or the database backups won't work. Basically, you are not going to be putting databases configured with FILESTREAM RBS on the same LUNs as database that are not enabled.