SharePoint 2010 Search result Not found documents for a specific library in specific SharePoint site

Hi All,

I came across a situation where user is trying to search documents selecting the option “search in same site” instead of “all sites” from  search box and getting no result where as can find documents from other library with in same site.

Why such happens ?

The first point comes to mind for search error is  content not crawled, indexing not done for this situation.

Yes , its true but we need to think why  ?

As per my investigation I found the setting of the library as below

Draft-items-are-not-crawled-in-SharePoint

By default SharePoint only crawls major versions of files and draft items are only viewable by their creators. SharePoint is behaving as expected out of box.Draft items are not crawled in SharePoint

Resolution :

This behavior can be altered in Document Library Settings -> Versioning Settings -> Draft Item Security

Select the option “Any user who can read items”.

This will allow all users to see draft items including the crawling account.

  • Else you need to select “Create major versions” option or can publish the documents as major versions if want to get those documents in search result as per client wish.

https://support.microsoft.com/en-us/help/2304855/draft-items-are-not-crawled-in-sharepoint

Advertisements

Crawl error Processing this item failed because of an unknown error when trying to parse its contents sharepoint

During various search troubleshooting i came across the following crawling error in the Crawl log of a SharePoint 2013 environment.

Processing this item failed because of an unknown error when trying to parse its contents. (Error parsing document ‘http://********.*****.com/Project/abcd/Q_M/ABX/SitePages/Homepage.aspx’. Sandbox worker pool is
closed.; ; SearchID = *******************)

In order to fix this you can try to perform the following action plan:
Open “Local Policies
Click on “User rights assignment

user-rights-assignment

Make sure that the search service account has the following rights:
Replace a process level token

adjust-memory-quotas-for-process

Adjust memory quotas for a process

adjust-memory-quotas-for-process-properties

Impersonate a client after authentication

impersonate

Please make sure that the policies don’t get changed afterwards.

After implementing the above changes please run a clear configuration cache
After clearing the cache, start a full crawl and the errors should be gone.

Start SharePoint Service Application Proxy using Powershell

If your Usage and Health Data Collection Proxy is in a stopped state here is a quick bit of PowerShell to to get it started:

$sap = Get-SPServiceApplicationProxy | where-object {$_.TypeName -eq “Usage and Health Data Collection Proxy”}
$sap.Provision()

The above can easily be adapted to allow you to start any Service Application Proxy

Slow SharePoint improve performance without upgrading hardware

what you can do if your SharePoint is sometimes very slow.

E.g.: on the first start of a Site
Sometimes during the day a search query will take about a minute until you get results…..

Just look on that article: http://support.microsoft.com/kb/2625048

it will improve “feeled” performance (site response times) massive, if you’re going to implement both solutions.

Disabling CRL Check is just necessary if the SP Server does not have internet connectivity, that means proxy settings must be configured for the server itself

http://technet.microsoft.com/de-de/library/bb430772(v=exchg.141).aspx, and your proxy must allow traffic from the server of course.

SharePoint item crawled returned error when attempting to download the item example aspx file

Error:

SharePoint Crawl Log Error: The SharePoint item being crawled returned an error when attempting to download the item for example .aspx files

Solution:

1.Open Regedit on your search server/s
2.Navigate to this registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\14.0\Search\Global\Gathering Manager
3.Change Value “UserAgent” from “MSIE 4.01” to “MSIE 8.0
4.Restart the SharePoint Search Service.
5.Open a SharePoint PowerShell
6.Get-SPSessionStateService
7.If this returns false then we need to deploy one
Enable-SPSessionStateService -DatabaseName “NameOfDatabase”

SharePoint shortcut URL and hidden list

Users and Permissions:
People and Groups: _layouts/people.aspx
Site Collection Admins: _layouts/mngsiteadmin.aspx
Advanced Permissions: _layouts/user.aspx
Master Pages: _Layouts/ChangeSiteMasterPage.aspx
Look and Feel:
Quick Launch settings page: /_layouts/quiklnch.aspx
Title, Desc, and Icon: _layouts/prjsetng.aspx
Navigation: _layouts/AreaNavigationSettings.aspx
Page Layout and Ste Templates: _Layouts/AreaTemplateSettings.aspx
Welcome Page: _Layouts/AreaWelcomePage.aspx
Tree View: _layouts/navoptions.aspx
Top Nav Bar: _layouts/topnav.aspx
Site Theme: _layouts/themeweb.aspx
Reset to Site Definition: _layouts/reghost.aspx
Searchable Columns: _Layouts/NoCrawlSettings.aspx
Site Content Types: _layouts/mngctype.aspx
Galleries
Site Columns: _layouts/mngfield.aspx
Site Templates: _catalogs/wt/Forms/Common.aspx
List Templates: _catalogs/lt/Forms/AllItems.aspx
Filter toolbar for Lists and libraries: ?Filter=1
Web Parts: _catalogs/wp/Forms/AllItems.aspx
Workflows: _layouts/wrkmng.aspx
Workflow history hidden list: /lists/Workflow History
Master Pages and Page Layouts: _catalogs/masterpage/Forms/AllItems.aspx
Regoinal Settings: _layouts/regionalsetng.aspx
Site Administration
Recreate default site sp groups: _layouts/15/permsetup.aspx
recycle bin: _layouts/RecycleBin.aspx
Site Libraries and Lists: _layouts/mcontent.aspx
Site Usage Report: _layouts/usageDetails.aspx
User Alerts: _layouts/sitesubs.aspx
RSS: _layouts/siterss.aspx
Search Visibility: _layouts/srchvis.aspx
Sites and Workspaces: _layouts/mngsubwebs.aspx
Site Features: _layouts/ManageFeatures.aspx
Delete This Site: _layouts/deleteweb.aspx
Site Output Cache: _Layouts/areacachesettings.aspx
Content and Structure: _Layouts/sitemanager.aspx
Content and Structure Logs: _Layouts/SiteManager.aspx?lro=all
Search Settings: _layouts/enhancedSearch.aspx
Site Collection Administration
Search Scopes: _layouts/viewscopes.aspx?mode=site
Search Keywords: _layouts/listkeywords.aspx
Recycle Bin: _layouts/AdminRecycleBin.aspx
Site Collection Features: _layouts/ManageFeatures.aspx?Scope=Site
Site Hierachy: _layouts/vsubwebs.aspx
Site hierarchy page (lists of sub sites): /_layouts/1033/vsubwebs.aspx
Portal Site Connection: _layouts/portal.aspx
Site Collection Audit Settings: _layouts/AuditSettings.aspx
Site Collection Policies: _layouts/Policylist.aspx
Site Collection Cache Profiles: Cache%20Profiles/AllItems.aspx
Site Collection Output Cache: _Layouts/sitecachesettings.aspx
Site Collection Object Cache: _Layouts/objectcachesettings.aspx
Variations: _Layouts/VariationSettings.aspx
Variation Labels: _Layouts/VariationLabels.aspx
Translatable Columns: _Layouts/TranslatableSettings.aspx
Variation Logs: _Layouts/VariationLogs.aspx
Site Settings: _layouts/settings.aspx
Delete user from Site collection (on-premises): /_layouts/15/people.aspx?MembershipGroupId=0

Load document tab initial
?InitialTabId=Ribbon.Document

Delete user from Site collection (on-premises):
/_layouts/15/people.aspx?MembershipGroupId=0

Display list in grid view. ‘True’ is case sensitive:
?ShowInGrid=True

Sandboxed Solution Gallery:
/_catalogs/solutions/Forms/AllItems.aspx

Filter toolbar for Lists and libraries:
?Filter=1

Site usage page:
/_layouts/usage.aspx

View all site content page (Site content):
/_layouts/viewlsts.aspx

Get the version of the SharePoint server (Patch level):
/_vti_pvt/Service.cnf

Web Part Maintenance Page:
?Contents=1

Show Page in Dialog View:
?isdlg=1

Application page for registering SharePoint apps
/_layouts/15/appregnew.aspx

Save Site as a template
/_layouts/savetmpl.aspx

Sign in as a different user
/_layouts/closeConnection.aspx?loginasanotheruser=true

Enable SharePoint designer
/_layouts/SharePointDesignerSettings.aspx

Quick Deploy List
Quick%20Deploy%20Items/AllItems.aspx

Open Page in Edit Mode
?ToolPaneView=2

Taxonomy Hidden List (MMS)
Lists/TaxonomyHiddenList/AllItems.aspx

User Information List:
_catalogs/users
_catalogs/users/simple.aspx

Force displaying the user profile in the site collection:
/_layouts/userdisp.aspx?id={UserID}&Force=True

Site hierarchy page (lists of sub sites)
/_layouts/vsubwebs.aspx
/_layouts/1033/vsubwebs.aspx

Add Web Parts Pane: ?ToolPaneView=2 : Add to the end of the page URL; will only work if the page is already checked out
Create: [area]/_layouts/spscreate.aspx
Create: /_layouts/create.aspx

Create list in a different portal area :

/_layouts/new.aspx?NewPageFilename=YourTemplateName.stp&ListTemplate=100&
ListBaseType=0

When you save a template in a portal area and try to create a new list in a different portal area, the template will not show on the Create page. Use this URL to force it to show.

Documents and Lists: /_layouts/viewlsts.aspx

List Template Gallery: /_catalogs/lt

Manage Audiences: /_layouts/Audience_Main.aspx

Manage Cross Site Groups: /_layouts/mygrps.aspx

Manage List Template Gallery: /_catalogs/lt/Forms/AllItems.aspx

Manage My Alerts: /_layouts/MySubs.aspx

Manage People: /_layouts/people.aspx

Manage Site Collection Administrators: /_layouts/mngsiteadmin.aspx

Manage Site Collection Users:
/_layouts/siteusrs.aspx : To access you must be an admin on the server or a site collection admin for the site.

Manage Site Groups: /_layouts/role.aspx

Manage Site Template Gallery: /_catalogs/wt/Forms/AllItems.aspx

Manage Site Template Gallery: /_catalogs/wt/Forms/Common.aspx

Manage Sites and Workspaces: /_layouts/mngsubwebs.aspx

Manage User Alerts: /_layouts/AlertsAdmin.aspx

Manage User Alerts: /_layouts/SiteSubs.aspx

Manage User Permissions: /_layouts/user.aspx

Manage Web Part Gallery: /_catalogs/wp/Forms/AllItems.aspx

Master Page Gallery: /_catalogs/masterpage : Also includes Page Layouts

Modify Navigation: /_layouts/AreaNavigationSettings.aspx

Recycle Bin: /_layouts/AdminRecycleBin.aspx

Save as site template: /_layouts/savetmpl.aspx

Site Column Gallery: /_layouts/mngfield.aspx

Site Content and Structure Manager: /_layouts/sitemanager.aspx

Site Content Types: /_layouts/mngctype.aspx

Site Settings: /_layouts/settings.aspx

Site Settings: /_layouts/default.aspx

Site Template Gallery: /_catalogs/wt

Site Theme: /_layouts/themeweb.aspx

Site usage details: /_layouts/UsageDetails.aspx

Site Usage Summary: /_layouts/SpUsageWeb.aspx

Site Usage Summary: /_layouts/Usage.aspx

Sites Registry: /SiteDirectory/Lists/Sites/Summary.aspx

Top-level Site Administration: /_layouts/webadmin.aspx

User Information: /_layouts/userinfo.aspx

Web Part Gallery: /_catalogs/wp

Web Part Page Maintenance: ?contents=1 : Add to the end of the page URL

Basic Powershell cmdlet sharepoint

Get-Command -Noun SP*
Get-Help Get-SPSite
Get-Help Get-SPSite -Examples
PS C:\Users\de.prasad.adm> Get-Command -Noun SPSite

CommandType Name ModuleName


Cmdlet Backup-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Copy-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Move-SPSite Microsoft.SharePoint.PowerShell
Cmdlet New-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Repair-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Restore-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Set-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Test-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Upgrade-SPSite Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPWeb

CommandType Name ModuleName


Cmdlet Export-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet Import-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet New-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet Set-SPWeb Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPWebApplication

CommandType Name ModuleName


Cmdlet Convert-SPWebApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebApplication Microsoft.SharePoint.PowerShell
Cmdlet New-SPWebApplication Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPWebApplication Microsoft.SharePoint.PowerShell
Cmdlet Set-SPWebApplication Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPServiceApplication

CommandType Name ModuleName


Cmdlet Get-SPServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Publish-SPServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Set-SPServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Unpublish-SPServiceApplication Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPServiceApplicationPool

CommandType Name ModuleName


Cmdlet Get-SPServiceApplicationPool Microsoft.SharePoint.PowerShell
Cmdlet New-SPServiceApplicationPool Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPServiceApplicationPool Microsoft.SharePoint.PowerShell
Cmdlet Set-SPServiceApplicationPool Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPContentDatabase

CommandType Name ModuleName


Cmdlet Dismount-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Mount-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet New-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Set-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Test-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Upgrade-SPContentDatabase Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPDatabase

CommandType Name ModuleName


Cmdlet Get-SPDatabase Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPManagedAccount

CommandType Name ModuleName


Cmdlet Get-SPManagedAccount Microsoft.SharePoint.PowerShell
Cmdlet New-SPManagedAccount Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPManagedAccount Microsoft.SharePoint.PowerShell
Cmdlet Set-SPManagedAccount Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun STimerJob
PS C:\Users\de.prasad.adm> Get-Command -Noun SPTimerJob

CommandType Name ModuleName


Cmdlet Disable-SPTimerJob Microsoft.SharePoint.PowerShell
Cmdlet Enable-SPTimerJob Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTimerJob Microsoft.SharePoint.PowerShell
Cmdlet Set-SPTimerJob Microsoft.SharePoint.PowerShell
Cmdlet Start-SPTimerJob Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun SPUser

CommandType Name ModuleName


Cmdlet Get-SPUser Microsoft.SharePoint.PowerShell
Cmdlet Move-SPUser Microsoft.SharePoint.PowerShell
Cmdlet New-SPUser Microsoft.SharePoint.PowerShell
Cmdlet Remove-SPUser Microsoft.SharePoint.PowerShell
Cmdlet Set-SPUser Microsoft.SharePoint.PowerShell
PS C:\Users\de.prasad.adm> Get-Command -Noun WebApplication

CommandType Name ModuleName


Cmdlet ConvertTo-WebApplication WebAdministration
Cmdlet Get-WebApplication WebAdministration
Cmdlet New-WebApplication WebAdministration
Cmdlet Remove-WebApplication WebAdministration
PS C:\Users\de.prasad.adm> Get-Command -Noun SPProcessAccount

CommandType Name ModuleName


Cmdlet Get-SPProcessAccount Microsoft.SharePoint.PowerShell

PS C:\Users\de.prasad.adm> Get-Command -Verb Get

Cmdlet Get-PfxCertificate Microsoft.PowerShell.Security
Cmdlet Get-PfxData PKI
Cmdlet Get-Process Microsoft.PowerShell.Management
Cmdlet Get-PSBreakpoint Microsoft.PowerShell.Utility
Cmdlet Get-PSCallStack Microsoft.PowerShell.Utility
Cmdlet Get-PSDrive Microsoft.PowerShell.Management
Cmdlet Get-PSProvider Microsoft.PowerShell.Management
Cmdlet Get-PSSession Microsoft.PowerShell.Core
Cmdlet Get-PSSessionConfiguration Microsoft.PowerShell.Core
Cmdlet Get-PSSnapin Microsoft.PowerShell.Core
Cmdlet Get-Random Microsoft.PowerShell.Utility
Cmdlet Get-ScheduledJob PSScheduledJob
Cmdlet Get-ScheduledJobOption PSScheduledJob
Cmdlet Get-SecureBootPolicy SecureBoot
Cmdlet Get-SecureBootUEFI SecureBoot
Cmdlet Get-Service Microsoft.PowerShell.Management
Cmdlet Get-SPAccessServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAccessServicesApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAccessServicesDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAccessServicesDatabaseServer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAccessServicesDatabaseServerGroup Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAccessServicesDatabaseServerGroupMapping Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAlternateURL Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppAcquisitionConfiguration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppAutoProvisionConnection Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppDeniedEndpointList Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppDisablingConfiguration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppDomain Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppHostingQuotaConfiguration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppInstance Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppPrincipal Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppScaleProfile Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppSiteSubscriptionName Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppStateSyncLastRunTime Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppStateUpdateInterval Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAppStoreConfiguration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAuthenticationProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPAuthenticationRealm Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBackupHistory Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBingMapsBlock Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBingMapsKey Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBrowserCustomerExperienceImprovementProgram Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBusinessDataCatalogEntityNotificationWeb Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBusinessDataCatalogMetadataObject Microsoft.SharePoint.PowerShell
Cmdlet Get-SPBusinessDataCatalogThrottleConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPCertificateAuthority Microsoft.SharePoint.PowerShell
Cmdlet Get-SPClaimProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPClaimProviderManager Microsoft.SharePoint.PowerShell
Cmdlet Get-SPClaimTypeEncoding Microsoft.SharePoint.PowerShell
Cmdlet Get-SPContentDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPContentDeploymentJob Microsoft.SharePoint.PowerShell
Cmdlet Get-SPContentDeploymentPath Microsoft.SharePoint.PowerShell
Cmdlet Get-SPCustomLayoutsPage Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDataConnectionFile Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDataConnectionFileDependent Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDeletedSite Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDesignerSettings Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDiagnosticConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDiagnosticsPerformanceCounter Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDiagnosticsProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPDistributedCacheClientSetting Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEduServiceSetting Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchAdministrationComponent Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchComponent Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchContentEnrichmentConfigur… Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlContentSource Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlCustomConnector Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlExtension Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlLogReadPermission Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlMapping Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchCrawlRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchFileFormat Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchHostController Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchLanguageResourcePhrase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchLinguisticComponentsStatus Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchLinksDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchMetadataCategory Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchMetadataCrawledProperty Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchMetadataManagedProperty Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchMetadataMapping Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchOwner Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchPropertyRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchPropertyRuleCollection Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryAndSiteSettingsService Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryAndSiteSettingsServi… Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryAndSiteSettingsServi… Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryAuthority Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryDemoted Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryKeyword Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryScope Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQueryScopeRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQuerySpellingCorrection Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchQuerySuggestionCandidates Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchRankingModel Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchResultItemType Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchResultSource Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchSecurityTrimmer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchService Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchServiceApplicationBackupS… Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchServiceInstance Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchSiteHitRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchStatus Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchTopology Microsoft.SharePoint.PowerShell
Cmdlet Get-SPEnterpriseSearchVssDataPath Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelBIServer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelBlockedFileType Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelDataConnectionLibrary Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelDataProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelFileLocation Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPExcelUserDefinedFunction Microsoft.SharePoint.PowerShell
Cmdlet Get-SPFarm Microsoft.SharePoint.PowerShell
Cmdlet Get-SPFarmConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPFeature Microsoft.SharePoint.PowerShell
Cmdlet Get-SPHealthAnalysisRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPHelpCollection Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInfoPathFormsService Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInfoPathFormTemplate Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInfoPathUserAgent Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInfoPathWebServiceProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInternalAppStateSyncLastRunTime Microsoft.SharePoint.PowerShell
Cmdlet Get-SPInternalAppStateUpdateInterval Microsoft.SharePoint.PowerShell
Cmdlet Get-SPIRMSettings Microsoft.SharePoint.PowerShell
Cmdlet Get-SPLogEvent Microsoft.SharePoint.PowerShell
Cmdlet Get-SPLogLevel Microsoft.SharePoint.PowerShell
Cmdlet Get-SPManagedAccount Microsoft.SharePoint.PowerShell
Cmdlet Get-SPManagedPath Microsoft.SharePoint.PowerShell
Cmdlet Get-SPMetadataServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPMetadataServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPMobileMessagingAccount Microsoft.SharePoint.PowerShell
Cmdlet Get-SPODataConnectionSetting Microsoft.SharePoint.PowerShell
Cmdlet Get-SPODataConnectionSettingMetadata Microsoft.SharePoint.PowerShell
Cmdlet Get-SPOfficeStoreAppsDefaultActivation Microsoft.SharePoint.PowerShell
Cmdlet Get-SPPendingUpgradeActions Microsoft.SharePoint.PowerShell
Cmdlet Get-SPPerformancePointServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPPerformancePointServiceApplicationTrusted… Microsoft.SharePoint.PowerShell
Cmdlet Get-SPPluggableSecurityTrimmer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProcessAccount Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProduct Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProfileLeader Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProfileServiceApplicationSecurity Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectDatabaseQuota Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectDatabaseState Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectEnterpriseProjectTaskSync Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectLogLevelManager Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectOdataConfiguration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectPCSSettings Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectPermissionMode Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectQueueSettings Microsoft.SharePoint.PowerShell
Cmdlet Get-SPProjectWebInstance Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRequestManagementSettings Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRoutingMachineInfo Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRoutingMachinePool Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRoutingRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSDatabaseCreationScript Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSDatabaseRightsScript Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSDatabaseUpgradeScript Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSExtension Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSProxyUrl Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSServiceApplicationServers Microsoft.SharePoint.PowerShell
Cmdlet Get-SPRSSite Microsoft.SharePoint.PowerShell
Cmdlet Get-SPScaleOutDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPScaleOutDatabaseDataState Microsoft.SharePoint.PowerShell
Cmdlet Get-SPScaleOutDatabaseInconsistency Microsoft.SharePoint.PowerShell
Cmdlet Get-SPScaleOutDatabaseLogEntry Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSecureStoreApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSecureStoreSystemAccount Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSecurityTokenServiceConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServerScaleOutDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServerScaleOutDatabaseDataState Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServerScaleOutDatabaseInconsistency Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServerScaleOutDatabaseLogEntry Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplicationEndpoint Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplicationPool Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplicationProxyGroup Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceApplicationSecurity Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceContext Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceHostConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPServiceInstance Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSessionStateService Microsoft.SharePoint.PowerShell
Cmdlet Get-SPShellAdmin Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSite Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteAdministration Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscription Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionEdiscoveryHub Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionEdiscoverySearchScope Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionFeaturePack Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionIRMConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteSubscriptionMetadataConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteUpgradeSessionInfo Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSiteURL Microsoft.SharePoint.PowerShell
Cmdlet Get-SPSolution Microsoft.SharePoint.PowerShell
Cmdlet Get-SPStateServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPStateServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPStateServiceDatabase Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTaxonomySession Microsoft.SharePoint.PowerShell
Cmdlet Get-SPThrottlingRule Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTimerJob Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTopologyServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTopologyServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTranslationThrottlingSetting Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTrustedIdentityTokenIssuer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTrustedRootAuthority Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTrustedSecurityTokenIssuer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPTrustedServiceTokenIssuer Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUpgradeActions Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUsageApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUsageDefinition Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUsageService Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUser Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserLicense Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserLicenseMapping Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserLicensing Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserSettingsProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserSettingsProviderManager Microsoft.SharePoint.PowerShell
Cmdlet Get-SPUserSolution Microsoft.SharePoint.PowerShell
Cmdlet Get-SPVisioExternalData Microsoft.SharePoint.PowerShell
Cmdlet Get-SPVisioPerformance Microsoft.SharePoint.PowerShell
Cmdlet Get-SPVisioSafeDataProvider Microsoft.SharePoint.PowerShell
Cmdlet Get-SPVisioServiceApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPVisioServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWeb Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebApplication Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebApplicationAppDomain Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebApplicationHttpThrottlingMonitor Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebPartPack Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWebTemplate Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWOPIBinding Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWOPISuppressionSetting Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWOPIZone Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWorkflowConfig Microsoft.SharePoint.PowerShell
Cmdlet Get-SPWorkflowServiceApplicationProxy Microsoft.SharePoint.PowerShell
Cmdlet Get-Tpm TrustedPlatformModule
Cmdlet Get-TpmEndorsementKeyInfo TrustedPlatformModule
Cmdlet Get-TpmSupportedFeature TrustedPlatformModule
Cmdlet Get-TraceSource Microsoft.PowerShell.Utility
Cmdlet Get-Transaction Microsoft.PowerShell.Management
Cmdlet Get-TroubleshootingPack TroubleshootingPack
Cmdlet Get-TypeData Microsoft.PowerShell.Utility
Cmdlet Get-UICulture Microsoft.PowerShell.Utility
Cmdlet Get-Unique Microsoft.PowerShell.Utility
Cmdlet Get-Variable Microsoft.PowerShell.Utility
Cmdlet Get-WebAppDomain WebAdministration
Cmdlet Get-WebApplication WebAdministration
Cmdlet Get-WebApplicationMonitoringStatus Microsoft.MonitoringAgent.Pow…
Cmdlet Get-WebAppPoolState WebAdministration
Cmdlet Get-WebBinding WebAdministration
Cmdlet Get-WebCentralCertProvider WebAdministration
Cmdlet Get-WebConfigFile WebAdministration
Cmdlet Get-WebConfiguration WebAdministration
Cmdlet Get-WebConfigurationBackup WebAdministration
Cmdlet Get-WebConfigurationLocation WebAdministration
Cmdlet Get-WebConfigurationLock WebAdministration
Cmdlet Get-WebConfigurationProperty WebAdministration
Cmdlet Get-WebFilePath WebAdministration
Cmdlet Get-WebGlobalModule WebAdministration
Cmdlet Get-WebHandler WebAdministration
Cmdlet Get-WebItemState WebAdministration
Cmdlet Get-WebManagedModule WebAdministration
Cmdlet Get-WebRequest WebAdministration
Cmdlet Get-Website WebAdministration
Cmdlet Get-WebsiteState WebAdministration
Cmdlet Get-WebURL WebAdministration
Cmdlet Get-WebVirtualDirectory WebAdministration
Cmdlet Get-WheaMemoryPolicy Whea
Cmdlet Get-WIMBootEntry Dism
Cmdlet Get-WinAcceptLanguageFromLanguageListOptOut International
Cmdlet Get-WinCultureFromLanguageListOptOut International
Cmdlet Get-WinDefaultInputMethodOverride International
Cmdlet Get-WindowsDriver Dism
Cmdlet Get-WindowsEdition Dism
Cmdlet Get-WindowsErrorReporting WindowsErrorReporting
Cmdlet Get-WindowsImage Dism
Cmdlet Get-WindowsImageContent Dism
Cmdlet Get-WindowsOptionalFeature Dism
Cmdlet Get-WindowsPackage Dism
Cmdlet Get-WindowsSearchSetting WindowsSearch
Cmdlet Get-WinEvent Microsoft.PowerShell.Diagnostics
Cmdlet Get-WinHomeLocation International
Cmdlet Get-WinLanguageBarOption International
Cmdlet Get-WinSystemLocale International
Cmdlet Get-WinUILanguageOverride International
Cmdlet Get-WinUserLanguageList International
Cmdlet Get-WmiObject Microsoft.PowerShell.Management
Cmdlet Get-WSManCredSSP Microsoft.WSMan.Management
Cmdlet Get-WSManInstance Microsoft.WSMan.Management

Query 0 Server Not Responding – Event ID 2587

Error :

SERVER1:
Windows 2008 R2 (x64)
SharePoint 2010

SERVER2:
Windows 2008 R2 (x64)
SQL 2008

Services running on SERVER1: (none as localsystem, localservice, networkservice)

SharePoint 2010 Administration (started/auto)

SharePoint 2010 Timer (started/auto)

SharePoint 2010 Tracing (started/auto)

SharePoint 2010 User Code Host (stopped/disabled)

SharePoint 2010 VSS Writer (stopped/manual)

SharePoint Foundation Search V4 (started/manual)

SharePoint Server Search 14 (started/manual)

The RELATED ISSUE(s):

Search/indexing is not working, and in return, backups are failing claiming:

Failure Message Object Query-0 (D: on SERVER1) failed in event On Backup

Search Service Application reports:

Index Partition – 0 – SERVER2Search_Service_Application_PropertyStoreDB_9a482efd99954748a062952a3d2617d7

Query Component 0 SERVER1 Not Responding

System Event Log on SERVER1 reports:

Event ID 2587

The following conditions are currently affecting index propagation to this server for search service application ‘Search Service Application’:

1. Query 0, catalog Main: failing to copy index files from crawl component 0 for 1490 minutes. Access is denied. 0x80070005

2. Query 0 is not being automatically disabled because the minimum number of ready query components per partition is 2.

Solution :

  1. Please try to disconnect the query server from the search topology,
  2. stop the Search service in central admin, clear the index files in the query server.
  3. After that, starts the search service instance using Start-SPServiceInstance PowerShell.

Run the following PowerShell to reset the Query server:

$ssa = Get-SPEnterpriseSearchServiceApplication -Identity “SSAName”
$queryComponents = $ssa | Get-SPEnterpriseSearchQueryTopology -Active | Get-SPEnterpriseSearchQueryComponent
$component = $queryComponents | where {$_.ServerName -eq “QueryServerName” }
$component.Recover()

SharePoint 2010 Cannot add the specified assembly to the GAC

Error:

“Cannot add the specified assembly to the GAC in SharePoint 2010”

We had a solution deployed numerous times as it houses a line of business process in SharePoint 2010. On performing Upgrade Solution via stsadm or Update-Solution via Power Shell , encountered the error: cannot add the specified assembly to the GAC.

We started by created a test solution package and deployed it on the environment which worked fine to identify whether the issue was with the Package or environment.

On updating the LOB Solution , it couldn’t add the assembly to the GAC for LOB WSP, on one of the WFE servers.

Performed an IISRESET and restarted the timer service on the failing WFE, deployed the WSP package again, it did work but when we tried updating it again at the later stage, got the same error.

Solution :

I had to rely on Process Explorer to figure out what process was using the DLL and from where. The beauty of this tool is, it displays the list of processes running on the server and what DLL’s its using.

You can do a Find for the DLL file from the top menu bar to identify the process which it’s using.

I figured out using the Process Explorer, the Timer Service Process was referring to DLL from c:windowsassemblytemp

I cleared the Temp folders which had the DLL, performed an IISRESET and restarted the Timer Service

This resolved the issue for me. You will have to identify what process is conflicting and troubleshoot the same accordingly.

Workflow Manager Disaster Recovery

Workflow Manager is an added value to the SharePoint 2013, in the previous versions workflow was part of the SharePoint on SharePoint 2013 there are 2 flavors you can use when developing workflows the first one is the SharePoint 2010 workflow and the second and new one is the new workflow manager which is now a separate component, when you install the new workflow manager it will allow to create SharePoint 2013 workflows.

The Architecture of the Workflow Manager depends on several separate databases to save the workflows so now the workflows are stored on those separate databases and not on the content databases so important in any backup and restore to make sure that all those workflows are backed up in case restoration is needed and while restoring there are important steps and scripts that needs to run in certain order to restore the workflow farm correctly.

I will be walking through the steps to restore the workflow farms and the scripts used can be found in this link Scripts

Backup Workflow Manager

There are some components/information which need to be backed up and stored in order to restore workflow manager.

  • Backup the following databases by following the Database backup procedures, the frequency of backup the DB is same as content databases.
Database Name Description
WFResourceManagementDB Workflow Manager Resource Management Store
WFInstanceManagementDB Workflow Manager Instance Management Store
SbGatewayDatabase Service Bus Gateway Database
SBMessageContainer01 – n Service Bus Message Container Databases
  • Document the users/passwords used while configuring workflow manager.
  • Copy all the certificates generated during initial Workflow Manager Configuration and the certificate password and Important to save the thumbnail of the service bus certificate.

Notes:

  • Certificates will exist on local certificates in personal folder and full trusted certificates folder all of them need to be exported specially the service bus certificate.
  • To know service bus certificate run the command Get-SBFarm the returned result will contain the farm certificate thumbprint, check this thumbprint on the local machine certificates in the personal folder.
  • Export certificate with private key.
  • Keep track of outage date and time when it happens as it will be needed.
  • Document all ports used during initial configuration.
  • Get the symmetric key using this command and save it. “Get-SBNamespace -Name WorkflowDefaultNamespace”.
  • Save all scopes names specially the one used to register the workflow manager farm to do that run the getscopes.ps1 script

Restore Workflow Manager

  • Prepare a new machine to install workflow manager on the same domain as old machines
  • Use the same accounts when the workflow manager was configured originally.
  • Make sure that App Management service/service application running and subscription service too
  • Make sure to have user profile and user profile synchronization running and run full synchronization.
  • Install workflow manager on new machine but don’t configure it.
  • To install workflow manager install web platform installer and search for “workflow manager refresh 1”
  • Restore the backed up databases.
    • Only the following database should be restored.
    • WFResourceManagementDB
    • WFInstanceManagementDB
    • SbGatewayDatabase
    • SBMessageContainer* (all message container DBs)
      • Note: Do not restore the WFManagementDB and SbManagementDb databases as they will be recreated as part of the restore operation.
  • Restore any needed content DBs, web applications and site collections.
  • Restore the certificates exported during backup.
  • Open an elevated SharePoint PowerShell (Run as Administrator) window on the new machine.
  • Copy all the scripts and the wfm.config to a folder and navigate to that folder from the SharePoint PowerShell console.
  • Run restoreWFStep1 script (modify the parameters in the script as appropriate first).
  • Run restoreWFStep2 script (modify the parameters in the script as appropriate first).
  • For each container database, run the previous step after modifying the parameters. (optional if more than container database exists)
  • Run restoreWFStep3 (modify the parameters in the script as appropriate and put the thumbprint for the imported certificate).
  • Run restoreWFStep4 (modify the parameters in the script as appropriate first).
  • Set-SBNamespace –PrimarySymmetricKey  keyvalue  -Name WorkflowDefaultNamespace
  • Open new SharePoint PowerShell as Administrator.
  • Navigate to the folder containing scripts from the SharePoint PowerShell console.
  • Run the following commands
    • $filename = Resolve-Path .wfm.config
    • [System.AppDomain]::CurrentDomain.SetData(“APP_CONFIG_FILE”, $filename.Path)
  • Run restoreWFStep5 script (modify the parameters in the script as appropriate first).
  • Run restoreWFStep6 script (modify the parameters in the script as appropriate first).
  • Adjust DNS for workflow manager.
  • In IIS make sure to have the binding with the port for http for the workflow manager IIS site
  • You may need to register the workflow farm with the scope name used in the original farm
    • Register-SPWorkflowService -SPSite “http:/webapplication” -WorkflowHostUri “http://workfowsite:12291 ” -AllowOAuthHttp -Force -ScopeName “MyScope”
    • This command needs to run on the SharePoint Farm.(It is optional step if the farm didn’t see the workflow)
  • Run the following timer jobs from the central admin
  • Workflow Auto Cleanup
  • Notification Timer Job
  • Hold Processing and Reporting
  • Bulk workflow task processing
  • Refresh Trusted Security Token Services Metadata feed [Farm job – Daily]

Notes:

To add other workflow manager servers, just import the certificate and run restoreWFStep4 (after modifying the parameters) and then run restoreWFStep6 (after modifying the parameters).

There are other cases for restoration, in case if the application servers are not affected only the SQL server in this case the uninstall workflow manager from existing application server and then follow the above steps, once done you can uninstall workflow manager from other nodes and install workflow manager  and reinstall it  but don’t configure it just use the commands in script of restoreWFStep4  and restoreWFStep6

There is other case when the the application server is affected, in this case prepare a new machine and apply the above steps, then for any other node you can install workflow manager but don’t configure it just run restoreWFStep4  and restoreWFStep6 in the scripts to add those nodes.