Contents
What is RBS database?
SQL Server Remote BLOB Store (RBS) is an optional add-on component that lets database administrators store binary large objects in commodity storage solutions instead of directly on the main database server. RBS is included on the SQL Server installation media, but is not installed by the SQL Server Setup program.
What is RBS in SQL Server?
The RBS feature enables applications, such as SharePoint Server, to store BLOBs in a location outside the content databases. The metadata for each BLOB is stored in the SQL Server database and the BLOB is stored in the RBS store. SharePoint Server uses the RBS feature to store BLOBs outside the content database.
How can store BLOB in SQL Server?
Options for Storing Blobs
- FILESTREAM (SQL Server) FILESTREAM enables SQL Server-based applications to store unstructured data, such as documents and images, on the file system.
- FileTables (SQL Server)
- Remote Blob Store (RBS) (SQL Server)
What is the purpose of Blob Storage?
Blob storage is optimized for storing massive amounts of unstructured data, such as text or binary data. Blob storage is ideal for: Serving images or documents directly to a browser. Storing files for distributed access.
Why is it called Blob Storage?
It allows users to store large amounts of unstructured data on Microsoft’s data storage platform. In this case, Blob stands for Binary Large Object, which includes objects such as images and multimedia files. These are known as unstructured data because they don’t follow any particular data model.
What is the purpose of remote Blob Storage ( RBS )?
RBS functionality allows documents and files of size larger than specified limit to be stored in a separate storage drive or device other than content database. This is very useful feature to effectively store large files or documents without rapidly increasing your content database size.
Is there a remote blob store in SQL Server?
SQL Server Remote BLOB Store (RBS) is an optional add-on component that lets database administrators store binary large objects in commodity storage solutions instead of directly on the main database server. RBS is included on the SQL Server 2017 installation media, but is not installed by the SQL Server Setup program.
When to use RBS in a database server?
By using lower-priced storage instead of more expensive storage on a databases server, you can save on costs. RBS saves storage resources when there are fewer large BLOBs. When there are many smaller files, there is no benefit.
For example, if you have 150 GB of RBS data and you have a content database that is 70 GB, this still exceeds the limits. In SharePoint Server, a binary large object (BLOB) is a file, such as a Microsoft Office document or a video file.