- In a deployment of Microsoft SharePoint Server, you host SharePoint databases in a Microsoft SQL Server AlwaysOn availability group for high availability.
- You define an availability group listener in a multisubnet environment.
- You configure SharePoint to use the listener to connect to SQL Server.
- You install and deploy Remote Blob Store (RBS) to store and access binary large objects by using SharePoint.
Important In this process, we recommend that you perform a SELECT INTO operation into a new table from [WSS_Content].[mssqlrbs] in order to back up the initial blob_storge_location data value before you perform the update.
Also, make sure that this connection string sets the Data Source parameter to the availability group listener.
For example, the UPDATE statement could resemble the following:
SET blob_store_location='Data Source=ag_listen;Initial Catalog=WSS_Content;Integrated Security=True;MultiSubnetFailover=True;Application Name="Remote Blob Storage FILESTREAM Provider"'
Article ID: 2956899 - Last Review: 2 May 2014 - Revision: 1