question

AshwinGidwani-7892 avatar image
0 Votes"
AshwinGidwani-7892 asked AshwinGidwani-7892 commented

Enable RBS in SharePoint 2019 with SQL server 2019

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

https://docs.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.

sql-server-generaloffice-sharepoint-server-administrationoffice-sharepoint-server-developmentoffice-sharepoint-server-customization
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AllenXu-MSFT avatar image
0 Votes"
AllenXu-MSFT answered AshwinGidwani-7892 commented

Hi @AshwinGidwani-7892 ,

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Let me provide some clarity on requirement

I want to use SharePoint 2019 Document Center site template as documents archival site.

Going SharePoint online is not an option for me as we cannot

I have 300TB of documents which will be rarely accessed. These documents are scattered on different places and there is requirement to have everything in one place.

So now if you can suggest what option is available in SharePoint to manage such huge data which is rarely accessed

Thanks

0 Votes 0 ·