SwissChecklist

Checklist: Microsoft SQL Server 2008 R2 Remote BLOB Storage (RBS) installieren und konfigurieren

Microsoft SQL Server 2008 R2 Remote BLOB Storage (RBS) installieren und konfigurieren für Microsoft SharePoint Foundation 2010

  • Diese Checkliste ermöglicht es, in SharePoint Foundation 2010 mehr als 10 GB grosse Datenbanken zu haben

    Show Details Show Substeps Show Substeps Show Substeps

  • Systemanforderungen prüfen

    Show Details Show Substeps Show Substeps Show Substeps

  • Microsoft SQL Server 2008 R2 (Express/Web/Standard/etc)

    Show Details Show Substeps Show Substeps Show Substeps
    Es muss Microsoft SQL Server 2008 R2 installiert sein. In SQL Server 2008 (standard bei SharePoint Foundation 2010 Standalone Installation) ist dieses Feature nicht verfügbar.
    Details Install and configure Remote BLOB Storage (RBS) with the FILESTREAM provider(SharePoint Foundation 2010)

  • Optional: SQL Server 2008 R2 installieren

    Show Details Show Substeps Show Substeps Show Substeps

  • FILESTREAM aktivieren auf SQL Server

    Show Details Show Substeps Show Substeps Show Substeps
    Quelle: http://msdn.microsoft.com/en-us/library/cc645923.aspx

  • SQL Server Configuration Manager öffnen

    Show Details Show Substeps Show Substeps Show Substeps
    Start > All Programs > Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server Configuration Manager

  • "SQL Server Services" auswählen (Baum-Navigation links)

    Show Details Show Substeps Show Substeps Show Substeps

  • Rechtsklick auf die SQL Instanz > Eigenschaften

    Show Details Show Substeps Show Substeps Show Substeps

  • Im Register "FILESTREAM" "Enable FILESTREAM for Transact-SQL access" UND "Enable FILESTREAM for file I/O streaming access" auswählen

    Show Details Show Substeps Show Substeps Show Substeps

  • Übernehmen/OK klicken

    Show Details Show Substeps Show Substeps Show Substeps

  • Filestream-Konfiguration übernehmen

    Show Details Show Substeps Show Substeps Show Substeps
    Dieses SQL ausführen im SQL Management Studio

    EXEC sp_configure filestream_access_level, 2
    RECONFIGURE

  • SQL Instanz neu Starten

    Show Details Show Substeps Show Substeps Show Substeps

  • FILESTREAM aktivieren auf SharePoint Content DB

    Show Details Show Substeps Show Substeps Show Substeps

  • Dieses SQL ausführen (Pfade & Passwort anpassen!)

    Show Details Show Substeps Show Substeps Show Substeps
    use [WSS_Content]
    if not exists (select * from sys.symmetric_keys where name = N'##MS_DatabaseMasterKey##')
    create master key encryption by password = N'Admin Key Password !2#4'
    if not exists (select groupname from sysfilegroups where groupname=N'RBSFilestreamProvider')
    alter database [WSS_Content]
    add filegroup RBSFilestreamProvider contains filestream
       
    alter database [WSS_Content]
    add file (name = RBSFilestreamFile, filename = 'c:\Blobstore') to filegroup RBSFilestreamProvider

  • Remote BLOB Storage auf SQL Server und DB aktivieren

    Show Details Show Substeps Show Substeps Show Substeps

  • Remote Blob Storage herunterladen

    Show Details Show Substeps Show Substeps Show Substeps
    Download bei Microsoft.com (Achtung: nicht über Doppelklick installieren/starten!)

  • Kommandozeile starten

    Show Details Show Substeps Show Substeps Show Substeps
    Start > Ausführen > cmd

  • in cmd ins Download-Verzeichnis wechseln

    Show Details Show Substeps Show Substeps Show Substeps

  • MsIexec ausführen (Parameter anpassen!)

    Show Details Show Substeps Show Substeps Show Substeps
    msiexec /qn /lvx* rbs_install_log.txt /i RBS.msi TRUSTSERVERCERTIFICATE=true FILEGROUP=PRIMARY DBNAME="WSS_Content" DBINSTANCE="COMPUTERNAME\SHAREPOINT" FILESTREAMFILEGROUP=RBSFilestreamProvider FILESTREAMSTORENAME=FilestreamProvider_1

  • Remote BLOB Storage in SharePoint aktivieren

    Show Details Show Substeps Show Substeps Show Substeps

  • SharePoint 2010 Management Shell starten

    Show Details Show Substeps Show Substeps Show Substeps
    Als Administrator ausführen

  • Dieses PowerShell ausführen (Parameter anpassen!)

    Show Details Show Substeps Show Substeps Show Substeps
    $cdb = Get-SPContentDatabase -WebApplication <http://SiteName>
    $rbss = $cdb.RemoteBlobStorageSettings
    $rbss.Installed()
    $rbss.Enable()
    $rbss.SetActiveProviderName($rbss.GetProviderNames()[0])
    $rbss

  • Remote BLOB Storage testen

    Show Details Show Substeps Show Substeps Show Substeps

  • Lade eine neue Datei im Sharepoint hoch

    Show Details Show Substeps Show Substeps Show Substeps

  • Im BLOB Storage Pfad sollte nun in einem Unterordner eine Datei mit einer ID abgelegt sein

    Show Details Show Substeps Show Substeps Show Substeps

  • New Step

    Show Details Show Substeps Show Substeps Show Substeps
Use this Checklist

Preview/Print

Use

Change

Sort

Delete Template