Migrate content into or out of RBS (SharePoint Foundation 2010)

This article describes how to migrate content into or out of Remote BLOB Storage (RBS), or to a different RBS provider.
After installing RBS and setting a content database to use RBS, all existing content in that database can be migrated into the database's active provider. You use the same Windows PowerShell 2.0 command to migrate content into or out of RBS, or to another RBS provider. When RBS is implemented, SQL Server itself is regarded as an RBS provider.
You can migrate content databases at any time, but we recommend that you perform migrations during low usage periods so that this activity does not cause performance degradation for users. Migration moves all content from the specified content database into the storage mechanism of the newly named provider.
This operation can be performed on any Web server in the farm. You only need to perform the operation one time on one Web server for each content database that you want to migrate.
To migrate a content database by using Windows PowerShell
  1. Verify that you meet the following minimum requirements: See Add-SPShellAdmin.
  2. On the Start menu, click All Programs.
  3. Click Microsoft SharePoint 2010 Products.
  4. Click SharePoint 2010 Management Shell.
  5. At the Windows PowerShell command prompt, type the commands in the following steps.
  6. To obtain the content database RBS settings object:
    $cdb=Get-SPContentDatabase <ContentDbName>
$rbs=$cdb.RemoteBlobStorageSettings
    Where <ContentDbName> is the name of the content database.
  7. To view a list of all RBS providers that are installed on the Web server:
    $rbs.GetProviderNames()
  8. To set the active RBS provider:
    $rbs.SetActiveProviderName(<NewProvider>)
    Where <NewProvider> is the name of the provider that you want to make active for this content database. If you want to migrate the content database out of RBS altogether and back into SQL Server inline storage, set this value to ().
  9. Migrate the data from RBS to the new provider or to SQL Server:
    $rbs.Migrate()

Comments

Post a Comment

Popular posts from this blog

SharePoint 2016 and 2019 Ports

http://sharepoint2016server.blogspot.com/2016/10/sharepoint-2016-ports-list.html SharePoint 2019: Distributed Cache : TCP Port 22233, 22236 : UDP Port N/A : Protocols ICMP Type 0 (ping) People Picker : TCP Port 53, 88, 135, 137–139, 389, 445, 636, 749, 750, 3268, 3269 : UDP Port N/A 53, 88, 137–139, 389, 445, 749 : UDP Port N/A : Protocols N/A Sandbox Service : TCP Port 32846 : UDP Port N/A : protocols N/A Search Crawler : TCP Port Web Application Ports Used (e.g., 80, 443) : UDP Port N/A : Protocols N/A Search Index : TCP Ports 16500–16519 : UDP Port N/A : Protocols N/A Service Applications : TCP Port 32843, 32844 : UDP Port N/A : Protocols N/A SQL Server : TCP Port 1433 (default) : UDP Port 1434 (default) : Protocols N/A WCF Services : TCP Port 808 : UDP Port N/A : Protocols N/A User Profile Service : TCP Port 53, 88, 389, 5725, 1025–5000, 49152–65536 : UDP Port 53, 88, 389, 464 : Protocols N/A SMTP : TCP Port 25 (default), 587 (TLS default) : UDP Port N/A : Protocols ...
Read more

Clear fields based on drop-down values in PowerApps

Clear current selection from drop down when another drop down value changes 1) Parent drop-down is States 2) Child drop-down is City We can hide and show the City drop-down based on States Value changes NOTE: Please use your DataCardValues and  lv_dpclear is local variable Select City data card and go to the Advanced properties for DataCard Look for the Visible property and write the below code If(DataCardValue3.Selected.Value="VA",true,false) For clearing the City dropdown selected value based state changes. Select the State drop-down (first drop-down) and go to Advanced use the below code in OnChange  UpdateContext({lv_dpclear: true}); UpdateContext({lv_dpclear: false})  In the Reset property of the second dropdown(City), add the below code       lv_dpclear -------------------------------------------------------------------- Clearing text box and Date Control values based on dropdown selection: Add belo...
Read more

Hide a SharePoint list field based on user group using JQuery Webservice in 2010

A field in a SharePoint list form like NewForm.aspx or EditForm.aspx can be easily hidden by using the following Jquery statements. Assume that we have an input field named Feedback var feedbackField = $("input[title=Feedback]"); feedbackField.parent().parent().parent().hide();    But what if we want to hide the field for a particular SharePoint user group only. Let's say we have a user group named "Test Group" and we don't want to show the Feedback field to the users of this group. In order to achieve this we need to know whether the current logged in user belongs to the "Test Group" or not.This can be done by using   SPServices , a Jquery library for SharePoint web services. Grab the latest version of SPServices Jquery library from codeple x and Jquery from here . Once you have both .js files, upload them to a SharePoint document library. In my case I created a folder named JS inside Shared Documents Document library and uploaded both files...
Read more