Wir haben ein tolles Whitepaper über RBS auf die Community Seite hochgeladen.
SQL_Server_2008_R2_Remote_Blob_Storage
So long, Samuel
Contents
Introduction: What is Remote BLOB Storage? ………………………………………………………………… 6
The Case for RBS …………………………………………………………………………………………………… 6
Large Database of Mostly Binary Data …………………………………………………………………….. 6
Digital Asset Management Databases …………………………………………………………………….. 7
When Storage Tiers Need to be Implemented ………………………………………………………….. 7
When Storage Needs to be Optimized …………………………………………………………………….. 7
Installing, Configuring, and Administering RBS ……………………………………………………………….. 8
Component Overview ………………………………………………………………………………………………. 8
RBS Feature Pack ……………………………………………………………………………………………….. 8
Important RBS Concepts ………………………………………………………………………………………….12
Entity Relationships ……………………………………………………………………………………………..12
Differences between LOCAL and REMOTE FILESTREAM Providers …………………………..13
High Availability Considerations ……………………………………………………………………………..14
Process Flow ………………………………………………………………………………………………………….15
BLOB Insert ………………………………………………………………………………………………………..15
BLOB Retrieval ……………………………………………………………………………………………………16
BLOB Delete ……………………………………………………………………………………………………….17
BLOB Delete Propagation ……………………………………………………………………………………..17
Pre-requisites and Required Resources ……………………………………………………………………..18
Enabling FILESTREAM for file I/O Streaming Access ……………………………………………….18
Setting the filestream_access_level Parameter …………………………………………………………20
Storage Architecture Considerations ………………………………………………………………………….20
Implementation Guidance …………………………………………………………………………………………21
Installing the RBS Feature Pack ………………………………………………………………………………..21
Database Preparation …………………………………………………………………………………………..21
Executing the RBS Feature Pack Installer ………………………………………………………………..21
Installing on Multiple Servers …………………………………………………………………………………32
Configuring RBS ……………………………………………………………………………………………………..33
BLOB Store Core Configuration Settings …………………………………………………………………33
BLOB Store Extended Configuration Settings …………………………………………………………..33
RBS Configuration Settings …………………………………………………………………………………..34
Uninstalling RBS (and the FILESTREAM Provider) ………………………………………………………36
Remove BLOB Store Database and Provider Configurations, Uninstall RBS …………………36
Maintenance and Administration………………………………………………………………………………..37
The Maintainer application …………………………………………………………………………………….37
Monitoring the BLOB Store ……………………………………………………………………………………38
Performance Counters ………………………………………………………………………………………….39
Database Resources ……………………………………………………………………………………………39
Backup and Restore ………………………………………………………………………………………………..40
Prescriptive Guidance …………………………………………………………………………………………..41
Synchronizing RBS Configuration with Backup Schedule …………………………………………..42
RBS Operational Issues …………………………………………………………………………………………..49
SharePoint 2010 and RBS …………………………………………………………………………………………..42
Differences between EBS and RBS ………………………………………………………………………..42
Enabling an RBS Provider in SharePoint 2010 …………………………………………………………43
Enabling the Provider on Multiple Content Databases ……………………………………………….45
Configuring RBS Security ……………………………………………………………………………………..46
Migrating Content To and From the BLOB Store ………………………………………………………….46
Migrate BLOB Data Back Inline in the Content Database ……………………………………………47
Disable RBS in the Content Database …………………………………………………………………….47
Uninstalling RBS (and the FILESTREAM Provider for SharePoint) ………………………………….47
Migrate BLOB Data Back Inline in the Content Database ……………………………………………48
Disable RBS in the Content Database …………………………………………………………………….48
Remove BLOB Store Database and Provider Configurations, Uninstall RBS …………………48
Guidance: Implementing RBS in a Custom Application ……………………………………………………49
Introduction: The Client Application Explained ……………………………………………………………..50
Client Library Reference …………………………………………………………………………………………..50
Using the RBS Client Library …………………………………………………………………………………….51
Environment Configuration …………………………………………………………………………………….51
BLOB Storage and Retrieval ………………………………………………………………………………….52
Deleting a BLOB ………………………………………………………………………………………………….54
Implementation Best Practices ……………………………………………………………………………….54
Guidance: Building an RBS Provider ……………………………………………………………………………..55
Implementation Guidance …………………………………………………………………………………………55
Max Buffer Size……………………………………………………………………………………………………55
OptimizationSpecifiedIds ……………………………………………………………………………………….56
Summary …………………………………………………………………………………………………………………56
sharepointszu 