Enable RBS in SharePoint 2019 with SQL server 2019

Ashwin Gidwani 1 Reputation point
2022-01-28T17:02:01.43+00:00

I have read in most of the Microsoft documents that, it requires SQL server 2016 to enable RBS on SharePoint 2019 server.

https://learn.microsoft.com/en-us/sharepoint/administration/install-and-configure-rbs

My question is it possible to enable RBS on SharePoint 2019 with SQL server 2019?

There is nowhere its been rejected or accepted in any of the documents.

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,217 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,573 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,798 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Allen Xu_MSFT 13,776 Reputation points
    2022-01-31T08:13:15.967+00:00

    Hi @Ashwin Gidwani ,

    Question is, why would you even want to use RBS with a version of SharePoint that only supports SQL Standard/Enterprise? RBS is supported, but you shouldn't use it. RBS was designed for those coming from SQL Express where there was (originally) a 4GB MDF limit. RBS introduces unnecessary complexity into the environment, primarily related to backup/restores/high availability. It also caps you at a hard 200GB database size limit (including RBS content) where as SharePoint storing docs in SQL supports 4TB+ databases. It is not designed to improve performance.

    As for storing GB-sized files, that would obviously be a question of what they are/what you're using them for and is SharePoint an appropriate storage location at all. For example, I wouldn't store ISOs in SharePoint because it doesn't serve a good purpose to do so.

    ----------

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.