Working with Content Databases in .NET framework

Making QR Code ISO/IEC18004 in .NET framework Working with Content Databases

Working with Content Databases
Read QR Code ISO/IEC18004 In .NET
Using Barcode Control SDK for .NET Control to generate, create, read, scan barcode image in VS .NET applications.
Making Denso QR Bar Code In .NET Framework
Using Barcode printer for .NET Control to generate, create QR Code ISO/IEC18004 image in .NET framework applications.
The BLOB storage settings can be configured using the RemoteBlobStorageSettings property The SPRemoteBlobStorageSettings object associated with this property supports the Installed() method, which we can use to check if the SQL Server RBS is installed on the content database
Decoding Quick Response Code In .NET Framework
Using Barcode recognizer for .NET framework Control to read, scan read, scan image in .NET framework applications.
Create Barcode In Visual Studio .NET
Using Barcode printer for .NET Control to generate, create barcode image in VS .NET applications.
PS > $spRBSSettings = $contentDBRemoteBlobStorageSettings PS > $spRBSSettingsInstalled() True
Bar Code Reader In .NET
Using Barcode scanner for .NET framework Control to read, scan read, scan image in .NET applications.
Encoding QR Code JIS X 0510 In C#
Using Barcode creation for Visual Studio .NET Control to generate, create Quick Response Code image in Visual Studio .NET applications.
Before we enable the resources required to use RBS, we set the value of the
QR Code JIS X 0510 Creator In .NET Framework
Using Barcode encoder for ASP.NET Control to generate, create Denso QR Bar Code image in ASP.NET applications.
Generate QR Code 2d Barcode In Visual Basic .NET
Using Barcode encoder for VS .NET Control to generate, create QR Code image in .NET applications.
ActiveProviderName property to the SQL Server RBS provider FILESTREAM_Blob_ Store in this example
Code 3 Of 9 Drawer In .NET Framework
Using Barcode creation for .NET Control to generate, create Code 39 image in .NET applications.
Linear Printer In .NET Framework
Using Barcode creator for .NET Control to generate, create Linear 1D Barcode image in Visual Studio .NET applications.
PS > $spRBSSettingsSetActiveProviderName("FILESTREAM_Blob_Store")
Bar Code Maker In .NET Framework
Using Barcode maker for .NET Control to generate, create barcode image in Visual Studio .NET applications.
Generating USPS OneCode Solution Barcode In VS .NET
Using Barcode drawer for VS .NET Control to generate, create USPS OneCode Solution Barcode image in .NET framework applications.
If you are uncertain of the SQL Server RBS provider name, you can use the
Encoding Bar Code In VB.NET
Using Barcode printer for .NET framework Control to generate, create bar code image in VS .NET applications.
GTIN - 12 Reader In Java
Using Barcode recognizer for Java Control to read, scan read, scan image in Java applications.
GetProviderNames() method to display the names of all SQL Server RBS providers
Generate UPC A In VB.NET
Using Barcode printer for .NET framework Control to generate, create UPC Code image in .NET applications.
Barcode Decoder In Visual Studio .NET
Using Barcode Control SDK for ASP.NET Control to generate, create, read, scan barcode image in ASP.NET applications.
registered on the content database
Barcode Reader In Visual C#.NET
Using Barcode scanner for .NET framework Control to read, scan read, scan image in Visual Studio .NET applications.
Encoding Data Matrix In Objective-C
Using Barcode drawer for iPhone Control to generate, create Data Matrix image in iPhone applications.
PS > $spRBSSettingsGetProviderNames() FILESTREAM_Blob_Store
Drawing Bar Code In Java
Using Barcode generator for BIRT Control to generate, create bar code image in BIRT reports applications.
DataMatrix Printer In Visual Basic .NET
Using Barcode maker for .NET Control to generate, create Data Matrix ECC200 image in VS .NET applications.
Finally, we enable the resources required to use RBS using the Enable() method
PS > $spRBSSettingsEnable()
It is also possible to set the minimum size of BLOBs stored in the BLOB store using the MinimumBlobStorageSize parameter By default, the value is set to 0, meaning that all BLOBs are stored in the BLOB store You can change the value so that only BLOBs larger than a specific size are stored in the BLOB store by supplying a new value as number of bytes In the following example, we set the value to 250KB so that BLOBs larger than 250KB are stored in the BLOB store and BLOBs smaller than 250KB are stored in the content database
PS > $spRBSSettingsMinimumBlobStorageSize = 250KB
Note that we use the multiplier suffix KB to represent the value in kilobytes Other supported multiplier suffixes are MB and GB To disable RBS on a content database, simply set the provider name to an empty string using the SetActiveProviderName() method, as shown here:
PS > $contentDB = Get-SPContentDatabase -Identity NimaIntra_ContentDB_01 PS > $spRBSSettings = $contentDBRemoteBlobStorageSettings PS > $spRBSSettingsSetActiveProviderName([string]::Empty)
PowerShell for Microsoft SharePoint 2010 Administrators
Additional Functionality in SharePoint 2010
You can attach and detach content databases from the Central Administration site, but it does not allow you to rename the databases To do that, you would need to detach the content databases manually one by one, change their names on the SQL Server instance, and then attach them with the new names When adding content databases to SharePoint, SharePoint will first check if a database with the specified name already exists If the existing database has no user-defined schema (that is, it is empty) or has a SharePoint-compatible schema, SharePoint will try to attach it If SharePoint does not find the database on the specified SQL Server instance, it will create the database for you The only way to control storage from Central Administration is to specify the maximum amount of site collections that should be stored in the content database This will not limit the size of the content database, unless you are using site quotas on your site collections
Summary
In this chapter, we first demonstrated how to go outside SharePoint, connect to a SQL Server instance, and used Windows PowerShell to run queries against content databases We stored the information about the configuration of some content databases in an XML file and used SharePoint cmdlets to detach and reattach the databases This example really demonstrated the power of Windows PowerShell It showed that you can work with SQL Server, XML files, and SharePoint within one and the same script In the second scenario, we looked at how to enable a content database to use RBS by installing the RBS FILESTREAM provider included in the Microsoft SQL Server 2008 R2 Feature Pack We then enabled RBS using Windows PowerShell and showed how to change vital RBS settings
Backup and Restore
PowerShell for Microsoft SharePoint 2010 Administrators
n this last chapter of the book, we will look at the options for backup and restore of SharePoint 2010 data using Windows PowerShell As we have mentioned earlier, backup and restore operations has been significantly improved in SharePoint 2010, offering administrators much more granularity and better tools to quickly recover from disasters or unintentional deletion of content Windows PowerShell cmdlets are available for backup and restore of items such as farm configuration, content databases, and Web applications The import and export cmdlets offer granular backup and restore options in SharePoint 2010 The new unattached content database feature of SharePoint 2010 lets you connect a content database to your farm without attaching it to any specific Web application This makes it possible to export items such as sites or lists for restoration purposes, without interfering with any of the Web applications running on the farm In SharePoint 2007, you needed a different stand-by farm to be able to accomplish these tasks In the last scenario, we will connect an unattached content database and demonstrate how to export sites and lists using only Windows PowerShell
Copyright © OnBarcode.com . All rights reserved.