Post reply

Configuring FILESTREAM for RBS

  • August 16, 2011 at 3:35 pm

    #255670

    Hi,

    We are implementing FILESTREAM for RBS in SQL Server 2008 R2 for Share point content databases.

    Steps Performed:

    Step 1:

    enabled FILESTREAM option Using SQL Server Configuration

    Step 2:

    sp_configure filestream_access_level,2

    reconfigure

    go

    Step3:

    Use WSS_Content_DB1

    go

    if not exists (select groupname from sysfilegroups where groupname=N'RBSFilestreamProvider')

    Alter database WSS_Content_DB1

    add filegroup RBSFilestreamProvider contains filestream

    Step4:

    Alter database WSS_Content_DB1

    add file (name = RBSFilestreamFile, filename = 'E:\Blobstore') to filegroup RBSFilestreamProvider

    Question:

    We have 10 Content databases and all of them required to store BLOB. So can we use the same path E:\Blobstore for all databases?

    I mean, can we run the STEP3 & STEP4 for all databases?

    Please advice

    Thanks

  • August 16, 2011 at 3:40 pm

    #1369347

    I would ensure the RBS filegroup for each content database had a different name. I would also test it heavily in a dev/qa environment and ensure it works. Nothing like testing first. Worst case, you would need separate folders for each DB.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 18, 2011 at 6:03 pm

    #1370477

    I'm doing the Filestream RBS configuration for the second database similarly as I did for first database

    Use WSS_Content_DB2

    go

    if not exists (select groupname from sysfilegroups where groupname=N'RBSFilestreamProvider')

    Alter database WSS_Content_DB1

    add filegroup RBSFilestreamProvider contains filestream

    Alter database WSS_Content_DB2

    add file (name = RBSFilestreamFile, filename = 'D:\Blobstore') to filegroup RBSFilestreamProvider

    But I'm getting the below error:

    Msg 5170, Level 16, State 2, Line 1

    Cannot create file 'D:\Blobstore' because it already exists. Change the file path or the file name, and retry the operation.

    Then I changed the filename i.e name = RBSFilestreamFile_new as below but still getting the same error

    Alter database WSS_Content_DB2

    add file (name = RBSFilestreamFile_new, filename = 'D:\Blobstore') to filegroup RBSFilestreamProvider

    Please advice

    Thanks

  • August 18, 2011 at 6:32 pm

    #1370484

    Change d:\blobstore to something like d:\blobstore2

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 18, 2011 at 10:32 pm

    #1370529

    It worked.

    So we need to have separate folder for each database:-D:-D

  • August 19, 2011 at 10:25 am

    #1370886

    Separate folder works, but more specificaly a separate file.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 19, 2011 at 10:39 am

    #1370895

    It worked.

    So we need to have separate folder for each database

    pork chop recipeBONELESS PORK CHOP RECIPES

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply