none
RBS support for SQL 2012 and SharePoint 2013 RRS feed

  • Question

  • Hi,

    Is there anyone who may know if SharePoint 2013 is supported with SQL 2012 RBS enabler (FileStream)? Haven't seen any official document from Microsoft stating that! The only information I found was regarding support för SQL 2008 R2 RBS and SharePoint 2013!


    Regards
    Henrik A. Halmstrand
    sharepointrevealed.com
    getspconfig.codeplex.com
    Please click Mark As Answer; if a post solves your problem or Vote As Helpful; if a post has been useful to you.

    Friday, May 24, 2013 1:03 PM

Answers

  • It supports RBS with SharePoint 2013 and SQL Server 2012, i have found an answer on RBS support with shredded storage in SP 2013 from the Microsoft virtual academy from one of the course by Bill Baer - Microsoft Senior Product Marketing Manager

     here is the link of the course https://www.microsoftvirtualacademy.com/training-courses/tuning-sql-server-2012-for-sharepoint-2013-jump-start

    Even RBS also support shredded storage which is a new concept in SharePoint 2013


    Mark this post as answer if this resolves your issue.


    Everything about SQL Server | Experience inside SQL Server -Mohammad Nizamuddin

    • Marked as answer by Emir Liu Thursday, June 6, 2013 10:24 AM
    Friday, May 24, 2013 6:21 PM
  • Hi.

    I could not find official documentation.

    Take however a look at this...

    http://stevemannspath.blogspot.it/2012/07/bang-two-pound-four-remote-blob-storage.html


    Regards,
    Bubu
    http://zsvipullo.blogspot.it

    Please mark my answer if it helped you, I would greatly appreciate it.

    • Marked as answer by Emir Liu Thursday, June 6, 2013 10:24 AM
    Friday, May 24, 2013 2:38 PM
  •  I have it working.  The SQL2008 documentation is close.  The biggest issues is --- download the RBS.msi from the SQL 2012 (sp1) feature pack.

    This was the most helpful online documentation I found.... http://stevemannspath.blogspot.com/2012/07/bang-two-pound-four-remote-blob-storage.html

    Some of the other issues I hit...

    • If you use DocAve (or will in the future), it will break RBS since it installs the 2008 dll's and does not give you options.  I have worked with both MS and AvePoint to identify this issue and they will be updating their product.
    • When setting minimum blob storage size, use 'set_MinimumBlobStorageSize' (see below)
    • Do not change the encryption password when creating master key in sql
    • If it's not clear run the msi on ALL servers in your farm, including database servers.  Run the "long" msiexec command on ONE server (i choose the active server in my SQL cluster).  Run the "short" command on the remaining servers.

    Here are the commands I used.  Some additional config was required to enable FILESTREAM on the SQL service, but that is well documented.

    SQL:

    EXEC sp_configure filestream_access_level, 2
    RECONFIGURE

    SP PowerShell:

    New-SPContentDatabase -Name "WSS_Content_RBS" -WebApplication "SharePoint - RBS" -DatabaseServer SQLDBSERVER

    SQL:

    use [WSS_Content_RBS]
    if not exists (select * from sys.symmetric_keys where name = N'##MS_DatabaseMasterKey##')
         create master key encryption by password = N'Admin Key Password !2#4'

    use [WSS_Content_RBS]
    if not exists (select groupname from sysfilegroups where groupname=N'RBSFilestreamProvider')
          alter database [WSS_Content_RBS]
          add filegroup RBSFilestreamProvider contains filestream

    use [WSS_Content_RBS]
    alter database [WSS_Content_RBS]
    add file (name = RBSFilestreamFile, filename= 'D:\RBS_Content')
          to filegroup RBSFilestreamProvider

    CMD Prompt First server:

    msiexec /qn /lvx* rbs_install_log.txt /i RBS.msi TRUSTSERVERCERTIFICATE=true FILEGROUP=PRIMARY DBNAME="WSS_Content_RBS" DBINSTANCE="SQLDBSERVER" FILESTREAMFILEGROUP=RBSFilestreamProvider FILESTREAMSTORENAME=FilestreamProvider_1

    CMD Prompt remaining servers:

    msiexec /qn /lvx* rbs_install_log.txt /i RBS.msi DBNAME="WSS_Content_RBS" DBINSTANCE="SQLDBSERVER" ADDLOCAL="Client,Docs,Maintainer,ServerScript,FilestreamClient,FilestreamServer"

    SP Powershell: (creates a site based on the record center template)

    New-SPSite -Url "https://sharepoint.domain.com/rbs" -OwnerAlias "DOMAIN\spadmin" -Name "RBS" -ContentDatabase "WSS_Content_RBS" -Template "OFFILE#1"

    SP Powershell:

    $site = Get-SPSite "https://sharepoint.domain.com/files"
    $db = $site.ContentDatabase
    $rbs = $db.RemoteBlobStorageSettings
    $rbs.Installed() # should return true
    $rbs.Enable()
    $rbs.SetActiveProviderName($rbs.GetProviderNames()[0])
    $rbs.set_MinimumBlobStorageSize(1048576)
    $db.Update()


    More notes...

    If you run $rbs.Migrate() you can move files into and out of the RBS storage depending upon the configuration of the active provider.  To disable RBS on a database...

    $site = Get-SPSite "https://sharepoint.domain.com/files"
    $db = $site.ContentDatabase
    $rbs = $db.RemoteBlobStorageSettings
    $rbs.Installed() # should return true
    $rbs.SetActiveProviderName("")
    $rbs.Migrate()
    $rbs.Disable()
    $db.Update()

    Send me a message if you run into trouble - I spent a lot of time on this and it does work.  A Microsoft tech I worked with to diagnose the DocAve issue also noted that the documentation needs to be updated.  They are working on that (one hopes)


    Friday, May 24, 2013 5:14 PM

All replies

  • Hi.

    I could not find official documentation.

    Take however a look at this...

    http://stevemannspath.blogspot.it/2012/07/bang-two-pound-four-remote-blob-storage.html


    Regards,
    Bubu
    http://zsvipullo.blogspot.it

    Please mark my answer if it helped you, I would greatly appreciate it.

    • Marked as answer by Emir Liu Thursday, June 6, 2013 10:24 AM
    Friday, May 24, 2013 2:38 PM
  •  I have it working.  The SQL2008 documentation is close.  The biggest issues is --- download the RBS.msi from the SQL 2012 (sp1) feature pack.

    This was the most helpful online documentation I found.... http://stevemannspath.blogspot.com/2012/07/bang-two-pound-four-remote-blob-storage.html

    Some of the other issues I hit...

    • If you use DocAve (or will in the future), it will break RBS since it installs the 2008 dll's and does not give you options.  I have worked with both MS and AvePoint to identify this issue and they will be updating their product.
    • When setting minimum blob storage size, use 'set_MinimumBlobStorageSize' (see below)
    • Do not change the encryption password when creating master key in sql
    • If it's not clear run the msi on ALL servers in your farm, including database servers.  Run the "long" msiexec command on ONE server (i choose the active server in my SQL cluster).  Run the "short" command on the remaining servers.

    Here are the commands I used.  Some additional config was required to enable FILESTREAM on the SQL service, but that is well documented.

    SQL:

    EXEC sp_configure filestream_access_level, 2
    RECONFIGURE

    SP PowerShell:

    New-SPContentDatabase -Name "WSS_Content_RBS" -WebApplication "SharePoint - RBS" -DatabaseServer SQLDBSERVER

    SQL:

    use [WSS_Content_RBS]
    if not exists (select * from sys.symmetric_keys where name = N'##MS_DatabaseMasterKey##')
         create master key encryption by password = N'Admin Key Password !2#4'

    use [WSS_Content_RBS]
    if not exists (select groupname from sysfilegroups where groupname=N'RBSFilestreamProvider')
          alter database [WSS_Content_RBS]
          add filegroup RBSFilestreamProvider contains filestream

    use [WSS_Content_RBS]
    alter database [WSS_Content_RBS]
    add file (name = RBSFilestreamFile, filename= 'D:\RBS_Content')
          to filegroup RBSFilestreamProvider

    CMD Prompt First server:

    msiexec /qn /lvx* rbs_install_log.txt /i RBS.msi TRUSTSERVERCERTIFICATE=true FILEGROUP=PRIMARY DBNAME="WSS_Content_RBS" DBINSTANCE="SQLDBSERVER" FILESTREAMFILEGROUP=RBSFilestreamProvider FILESTREAMSTORENAME=FilestreamProvider_1

    CMD Prompt remaining servers:

    msiexec /qn /lvx* rbs_install_log.txt /i RBS.msi DBNAME="WSS_Content_RBS" DBINSTANCE="SQLDBSERVER" ADDLOCAL="Client,Docs,Maintainer,ServerScript,FilestreamClient,FilestreamServer"

    SP Powershell: (creates a site based on the record center template)

    New-SPSite -Url "https://sharepoint.domain.com/rbs" -OwnerAlias "DOMAIN\spadmin" -Name "RBS" -ContentDatabase "WSS_Content_RBS" -Template "OFFILE#1"

    SP Powershell:

    $site = Get-SPSite "https://sharepoint.domain.com/files"
    $db = $site.ContentDatabase
    $rbs = $db.RemoteBlobStorageSettings
    $rbs.Installed() # should return true
    $rbs.Enable()
    $rbs.SetActiveProviderName($rbs.GetProviderNames()[0])
    $rbs.set_MinimumBlobStorageSize(1048576)
    $db.Update()


    More notes...

    If you run $rbs.Migrate() you can move files into and out of the RBS storage depending upon the configuration of the active provider.  To disable RBS on a database...

    $site = Get-SPSite "https://sharepoint.domain.com/files"
    $db = $site.ContentDatabase
    $rbs = $db.RemoteBlobStorageSettings
    $rbs.Installed() # should return true
    $rbs.SetActiveProviderName("")
    $rbs.Migrate()
    $rbs.Disable()
    $db.Update()

    Send me a message if you run into trouble - I spent a lot of time on this and it does work.  A Microsoft tech I worked with to diagnose the DocAve issue also noted that the documentation needs to be updated.  They are working on that (one hopes)


    Friday, May 24, 2013 5:14 PM
  • It supports RBS with SharePoint 2013 and SQL Server 2012, i have found an answer on RBS support with shredded storage in SP 2013 from the Microsoft virtual academy from one of the course by Bill Baer - Microsoft Senior Product Marketing Manager

     here is the link of the course https://www.microsoftvirtualacademy.com/training-courses/tuning-sql-server-2012-for-sharepoint-2013-jump-start

    Even RBS also support shredded storage which is a new concept in SharePoint 2013


    Mark this post as answer if this resolves your issue.


    Everything about SQL Server | Experience inside SQL Server -Mohammad Nizamuddin

    • Marked as answer by Emir Liu Thursday, June 6, 2013 10:24 AM
    Friday, May 24, 2013 6:21 PM
  • That's a great link, and not just for RBS.
    Saturday, May 25, 2013 2:05 PM
  • Hi David,

    When you have multiple content databases, how does that change the msiexec rbs.msi commands?  Do you repeat it for each content db?  Would I put in a different filestreamstorename or does that remain the same?

    Thursday, December 26, 2013 11:49 PM