Task 1: Enable the FILESTREAM Provider



Lab A (Module 2)This document is provided “as-is”. Information and views expressed in this document, including URL and other Internet Web site references, may change without notice. You bear the risk of using it. This document does not provide you with any legal rights to any intellectual property in any Microsoft product. You may copy and use this document for your internal, reference purposes. ? 2011 Microsoft. All rights reserved.Contents TOC \o "1-3" \h \z \u Task 1: Enable the FILESTREAM Provider PAGEREF _Toc298747591 \h 3Task 2: Provision a BLOB Store with the FILESTREAM Provider PAGEREF _Toc298747592 \h 4Task 3: Enable and Verify RBS PAGEREF _Toc298747593 \h 4Lab Summary PAGEREF _Toc298747594 \h 5In this lab, you implement Remote BLOB Storage for a content database in SharePoint 2010. You begin by first enabling the FILESTREAM provider, then provisioning a BLOB store, and finally enabling and verifying Remote BLOB Storage.Task 1: Enable the FILESTREAM ProviderIn this task, you enable and configure the FILESTREAM RBS provider for SQL Server 2008 R2.On the Start menu, point to All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.In the list of services, right-click SQL Server Services, and then click Open.In the SQL Server Configuration Manager snap-in, locate the instance of SQL Server on which you want to enable FILESTREAM.Right-click the instance and then click Properties.In the SQL Server Properties dialog box, click the FILESTREAM tab.Select the Enable FILESTREAM for Transact-SQL access check box.Click Apply, and then click OK.On the Start menu, point to All Programs, point to Microsoft SQL Server 2008 R2, and then click SQL Server Management Studio.In SQL Server Management Studio, select the WSS_Content_c4ed960e12af4e94869b0df181c5925b database, and then click New Query to display the Query Editor.In Query Editor, enter the following statements:EXECsp_configurefilestream_access_level, 2RECONFIGUREClick Execute.Task 2: Provision a BLOB Store with the FILESTREAM ProviderIn this task, you provision a new BLOB store in SQL Server 2008 R2. This BLOB store is used for documents associated with a specific content database.Click Start, click All Programs, click Microsoft SQL Server 2008R2, and then click SQL Server Management Studio. Enter the local server name and administrator credentials.Expand Databases.Select the WSS_Content_c4ed960e12af4e94869b0df181c5925b database, and then click New Query.In the Query pane, execute each of the following statements in sequence:useWSS_Content_c4ed960e12af4e94869b0df181c5925bif not exists (select * from sys.symmetric_keys where name = N'##MS_DatabaseMasterKey##')create master key encryption by password = N'Admin Key Password !2#4'useWSS_Content_c4ed960e12af4e94869b0df181c5925bif not exists (select groupname from sysfilegroups where groupname=N'RBSFilestreamProvider')alter database WSS_Content_c4ed960e12af4e94869b0df181c5925b add filegroupRBSFilestreamProvider contains filestreamuseWSS_Content_c4ed960e12af4e94869b0df181c5925balter database WSS_Content_c4ed960e12af4e94869b0df181c5925b add file (name = RBSFilestreamFile, filename = 'c:\Blobstore') to filegroupRBSFilestreamProviderTask 3: Enable and Verify RBSIn this task, you use PowerShell to enable RBS in SharePoint 2010, upload a file into a document library, and confirm that the RBS provider stores the file on the file system as specified.On the Start menu, click Programs, click Microsoft SharePoint 2010 Products, and then click SharePoint 2010 Management Shell.At the Windows PowerShell command prompt, type each of the following commands in sequence:$cdb = Get-SPContentDatabase -WebApplication$rbss = $cdb.RemoteBlobStorageSettings$rbss.Installed()$rbss.Enable()$rbss.SetActiveProviderName($rbss.GetProviderNames()[0])$rbssBrowse to , select Shared Documents, click the Documents option in the Ribbon, and then click Upload Document.Select RBTest.docx from the c:\Module 02 directory, and then click OK.In Windows Explorer, browse to the c:\Blobstore directory, open the folder with the most recent modified date, and validate that the RBTest.docx file exists in the folder.Lab Summary ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download