Configuring the Database to Use RBS in VS .NET

Making QR-Code in VS .NET Configuring the Database to Use RBS

Configuring the Database to Use RBS
QR Code Scanner In .NET
Using Barcode Control SDK for Visual Studio .NET Control to generate, create, read, scan barcode image in Visual Studio .NET applications.
Drawing QR Code 2d Barcode In Visual Studio .NET
Using Barcode creation for .NET framework Control to generate, create QR Code 2d barcode image in .NET applications.
First, you need to enable the FILESTREAM provider on SQL Server In the SQL Server Configuration Manager console, select the SQL Server Services node (on the left side of the window), right-click the SQL Server service instance for which you want to enable the FILESTREAM provider, and select Properties In the dialog box, select the FILESTREAM tab, select the Enable FILESTREAM for Transact-SQL access check box, and specify the name of a file share to use, as shown in Figure 20-1
Decode QR Code In .NET
Using Barcode recognizer for .NET framework Control to read, scan read, scan image in VS .NET applications.
Paint Barcode In .NET
Using Barcode maker for Visual Studio .NET Control to generate, create bar code image in .NET applications.
Figure 20-1
Read Bar Code In Visual Studio .NET
Using Barcode scanner for Visual Studio .NET Control to read, scan read, scan image in .NET framework applications.
Generate Denso QR Bar Code In C#
Using Barcode encoder for Visual Studio .NET Control to generate, create QR Code ISO/IEC18004 image in .NET framework applications.
Enabling the FILESTREAM provider on a SQL Server instance
QR Code Encoder In .NET Framework
Using Barcode encoder for ASP.NET Control to generate, create QR-Code image in ASP.NET applications.
Create Denso QR Bar Code In VB.NET
Using Barcode drawer for Visual Studio .NET Control to generate, create QR image in Visual Studio .NET applications.
20:
Bar Code Printer In .NET Framework
Using Barcode creation for Visual Studio .NET Control to generate, create barcode image in .NET applications.
Make EAN13 In Visual Studio .NET
Using Barcode printer for .NET framework Control to generate, create EAN-13 Supplement 5 image in .NET applications.
Working with Content Databases
Making Barcode In VS .NET
Using Barcode drawer for .NET Control to generate, create bar code image in VS .NET applications.
Encode ISBN - 13 In .NET Framework
Using Barcode generator for VS .NET Control to generate, create ISBN image in .NET applications.
Next, you need to set the correct access level In the following example, we use the
EAN / UCC - 14 Generator In None
Using Barcode creator for Software Control to generate, create UCC - 12 image in Software applications.
Create Bar Code In None
Using Barcode printer for Font Control to generate, create bar code image in Font applications.
Set-SQL function we created earlier in this chapter to set the FILESTREAM access level
Encode EAN / UCC - 14 In Java
Using Barcode maker for Java Control to generate, create EAN128 image in Java applications.
UPC A Generator In None
Using Barcode creator for Online Control to generate, create UPC A image in Online applications.
to 2, which enables Transact-SQL and allows Win32 APIs to work with the files
GS1-128 Decoder In VB.NET
Using Barcode reader for .NET Control to read, scan read, scan image in Visual Studio .NET applications.
Barcode Creation In Visual Basic .NET
Using Barcode encoder for .NET framework Control to generate, create bar code image in .NET applications.
PS > $conn = >> "server=SQLServer01;database=NimaIntra_ContentDB_01;trusted_connection=true;" PS > $command = "EXEC sp_configure filestream_access_level, 2 RECONFIGURE" PS > Set-SQL -command $command -connectionString $conn
Code 128 Code Set B Drawer In .NET
Using Barcode creation for Reporting Service Control to generate, create ANSI/AIM Code 128 image in Reporting Service applications.
Drawing Bar Code In VS .NET
Using Barcode creation for Reporting Service Control to generate, create bar code image in Reporting Service applications.
After the FILESTREAM provider is enabled and the access level is set to 2, we can provision a BLOB store First, we check if a master key exists If not, we create one with a specific password, as demonstrated here:
PS >> >> PS > $command = "IF NOT EXISTS (SELECT * FROM syssymmetric_keys " + "WHERE name = N'##MS_DatabaseMasterKey##') CREATE master key encryption " + "BY password = N'P@assw0rd'" > Set-SQL -command $command -connectionString $conn
Next, we add a new filegroup, specifying CONTAINS FILESTREAM
PS >> >> PS > $command = "IF NOT EXISTS (SELECT groupname FROM sysfilegroups WHERE " + "groupname=N'RBSFSProvider')ALTER DATABASE [NimaIntra_ContentDB_01] " + "ADD FILEGROUP RBSFSProvider CONTAINS FILESTREAM" > Set-SQL -command $command -connectionString $conn
The last step is to add a virtual file to the newly created filegroup and associate it with a directory on the local file system Note that the lowest level directory specified in the path must not exist The folder will be created by the Transact-SQL command
PS > $command = "alter database [NimaIntra_ContentDB_01] add file " + >> "(name = RBSFSFile, filename = 'C:\Blobstore') to filegroup RBSFSProvider" PS > Set-SQL -command $command -connectionString $conn
The database is now configured to use RBS
Installing the RBS Provider
Now you need to install the RBS provider on all the Web servers in the SharePoint 2010 farm Download the RBSmsi from the SQL Server 2008 R2 Feature Pack, at http:// gomicrosoftcom/fwlink/ LinkID=177388 Next, run the following command on the first Web server to start the installation
PS > msiexec /qn /l*v C:\BLOB\Install_logtxt /i C:\BLOB\RBSmsi TRUSTSERVERCERTIFICATE=true FILEGROUP=PRIMARY DBNAME="NimaIntra_ContentDB_01" DBINSTANCE="sqlserver01" FILESTREAMFILEGROUP=RBSFSProvider FILESTREAMSTORENAME=FILESTREAM_Blob_Store
PowerShell for Microsoft SharePoint 2010 Administrators
This has the Microsoft Installer program install the RBS provider on the Web server We use the following parameters in this example: We set the UI level using the /qn parameter, so that a silent installation is performed We specify that a log file should be created and that the log file should contain all available information, including verbose output, by using the /l*v parameter followed by the path to the log file We use the /i parameter and specify the path to the package that should be installed We set TRUSTSERVERCERTIFICATE to true so that connecting clients trust the self-signed certificate for encrypted connections initiated by RBS The FILEGROUP parameter sets the filegroup for internal tables The DBNAME parameter indicates which database to use the NimaIntra_ ContentDB_01 database in this example The DBINSTANCE parameter points to the SQL Server instance We specify the FILESTREAM BLOB store filegroup using the
FILESTREAMFILEGROUP parameter, pointing it to the FILESTREAM group
created in an earlier example We set a new FILESTREAM store name with the FILESTREAMSTORENAME parameter The command can take a while to complete If you want to wait until the command completes, you can use the Get-Process and Wait-Process cmdlets supported by Windows PowerShell, as follows:
PS > Get-Process msiexec | Wait-Process
The RBS provider also needs to be installed on all additional Web front end servers Since the connection to the FILESTREAM group already exists, we specify the components to install using the ADDLOCAL parameter
PS > msiexec /qn /l*v C:\BLOB\Install_logtxt /i C:\BLOB\RBSmsi DBNAME="NimaIntra_ContentDB_01" DBINSTANCE="sqlserver01" ADDLOCAL="Client,Docs,Maintainer,ServerScript, FilestreamClient,FilestreamServer"
Enabling RBS in SharePoint 2010
The final step is to enable RBS in SharePoint 2010 First, use the Get-SPContentDatabase cmdlet to return a database
PS > $contentDB = Get-SPContentDatabase -Identity NimaIntra_ContentDB_01
20:
Copyright © OnBarcode.com . All rights reserved.