none
Why SharePoint saves BOLB's in database natively?

    Question

  • Hi everyone, 

    I've read  a lot of documents where is mentioned the benefits of RBS and why not to use EBS to store BLOB's out of our database.

    But, I  haven't found an article which explain why sharepoint uses databases for storing BOLB's natively. So, I would like someone to give me some information or reference about this.

    Thank you very much.

    Thursday, February 16, 2012 4:44 PM

Answers

  • I don't believe there is an official reason, other than it is easier to create a database column to store a binary object than to create a remote storage provider.

    Also, historically when SharePoint Portal Server 2001 was released, SQL Server 2000 was the RDBMS platform and it didn't support EBS or RBS, functionality that was part of SQL Server 2005. None of the SharePoint products until MOSS had this support either, and EBS with SQL Server 2005 was limited as well.

    From an operations standpoint, storing the blobs in the database simplifies the solution. There are no "extra bits" you need to remember about, deploy, or support.


    Jason Warren
    Infrastructure Specialist
    Habañero Consulting Group
    www.habaneros.com/blog

    • Marked as answer by Rodr0 Friday, February 17, 2012 7:33 PM
    Thursday, February 16, 2012 6:23 PM

All replies

  • I don't believe there is an official reason, other than it is easier to create a database column to store a binary object than to create a remote storage provider.

    Also, historically when SharePoint Portal Server 2001 was released, SQL Server 2000 was the RDBMS platform and it didn't support EBS or RBS, functionality that was part of SQL Server 2005. None of the SharePoint products until MOSS had this support either, and EBS with SQL Server 2005 was limited as well.

    From an operations standpoint, storing the blobs in the database simplifies the solution. There are no "extra bits" you need to remember about, deploy, or support.


    Jason Warren
    Infrastructure Specialist
    Habañero Consulting Group
    www.habaneros.com/blog

    • Marked as answer by Rodr0 Friday, February 17, 2012 7:33 PM
    Thursday, February 16, 2012 6:23 PM
  • I think the disadvantages of using RBS and Filestream such as disabled database snapshots, not be able to use mirroring and others, could be an answer.

    Do you agree?

     
    Thursday, February 16, 2012 8:40 PM