SQLAuthority News – Remote BLOB Store Provider Library Implementation Specification

Remote BLOB Store Provider Library Implementation Specification
logo-sql08.gif
SQL Server Technical Article
Writers: Kevin Farlee, Pradeep Madhavarapu
Technical Reviewer: Pradeep Madhavarapu, Michael Warmington
Published: August 2008

Remote BLOB Store (RBS) is designed to move the storage of large binary data (BLOBs) from database servers to commodity storage solutions.

With RBS, BLOB data is stored in storage solutions such as Content Addressable Stores (CAS), commodity hardware with data integrity and fault-tolerance systems, or mega service storage solutions like MSN Blue. A reference to the BLOB is stored in the database. An application stores and accesses BLOB data by calling into the RBS client library. RBS manages the life cycle of the BLOB, such as doing garbage collection as and when needed.

RBS is an add-on that can be applied to Microsoft SQL Server 2008 and later. It uses auxiliary tables, stored procedures, and an executable to provide its services. A reference to the BLOB (provided by the BLOB Store) is stored in RBS auxiliary tables and an RBS BLOB ID is generated. Applications store this RBS BLOB ID in a column in application tables. These columns in application tables are called RBS Columns in this specification. The RBS Column is not a new data type; it is just a simple binary(20).

Above words are quoted from original Microsoft White Paper Please read complete white paper for excellent notes on what are exact specification for Remote BLOB Store Provider Library.

Abstract courtesy : Microsoft

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

2 thoughts on “SQLAuthority News – Remote BLOB Store Provider Library Implementation Specification

  1. How we can get the data in resultset from two different database server(SQL Server) having same table structure on both table into these two servers…?

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s