Copy SharePoint List or Library between Sites with PowerShell

In a migration project, we had to move a few lists and libraries to a different site collection. In SharePoint 2010, using granular export, we can export SharePoint lists and libraries from one site to another with the SharePoint Central Administration web interface. Once exported we’ve to use Import-SPWeb PowerShell cmdlet to…

Read more

Rotating Banner for SharePoint using jQuery

With jQuery we can do lot of user interface enhancements in SharePoint. In this article, I’m exploring one of them: Add rotating banner for SharePoint using jQuery, Let our SharePoint site display moving top banner. Lets start building rotating banner for SharePoint! jQuery Rotating Banner for SharePoint – Steps by Step: Here…

Read more

Set SharePoint Web Application or Farm to Read Only Mode

During maintenance/migrations, it’s inevitable to set the entire SharePoint Farm or at least Web Applications to read-only mode for some time. SharePoint doesn’t provide any direct ways to set the entire web application or Farm to Read-only mode, but we have these options available to set read only access to either SharePoint…

Read more

SharePoint 2010 Search Error: The search request was unable to connect to the Search Service.

After configuring the SharePoint search service application, Got this error message when I attempt to do a search: “The search request was unable to connect to the Search Service” I verified search settings, crawl logs and found they are fine. After a while nailed the issue: Search Service proxy association. Fix is…

Read more

Configure Diagnostic Logging in SharePoint 2010 – Best Practices, FAQs

What is Diagnostic Logging in SharePoint, By the way?Simple! Diagnostic logging is where SharePoint logs its own actions. There are two log file locations where SharePoint Diagnostic logging keeps its logs: Windows Event Log – You can view it with “Event Viewer” – The one comes with Windows! ULS or “Trace Log”…

Read more

Create or Delete Managed Path in SharePoint using PowerShell

Managed paths in SharePoint enables us to create a uniform navigational structure to group multiple site collections together. SharePoint Managed Paths can be defined using PowerShell or STSADM command-line tool. Managed paths are explained in my other article: Managed path in SharePoint Create Managed Path in SharePoint using PowerShell: Use New-SPManagedPath cmdlet…

Read more

Check Lock Status for All Site Collections in SharePoint

End user came with a compliant: “I’m receiving ‘HTTP 403: The Website declined to Show this webpage’ in some sites”, in an intranet collaboration environment. Ah! This is because: site is locked with “No Access”. How to Check Site Lock Status? You can navigate to: Central Administration > Application Management > Configure…

Read more

SharePoint Managed Paths Explained

Let me document the Frequently Asked Questions on SharePoint Managed Paths during my training sessions: What is Managed Path in SharePoint? A managed path is a location within a web application in which you can have site collections. When you create a web application, there are two managed paths created with it….

Read more

Export SharePoint Survey Results to Excel

Requirement: is to consolidate and analyze a SharePoint survey results by exporting the data to Excel Spreadsheet. Solution: Go to the survey overview page, Export SharePoint survey results to excel by clicking  Actions >> Export to Spreadsheet SharePoint 2010 Survey Export to Spreadsheet missing? Received end-user support tickets with the complaint: SharePoint…

Read more

SharePoint SQL Server Database Went Offline Mode – How to Bring it back to Online?

Problem: Suddenly SharePoint Database Went Offline!Analyzed Event Logs and found the Database went offline because of Backup failure.SQL Server: How to Bring Database Online? Alright, How to Bring it back Online? One line T-SQL! ALTER DATABASE STS_G1WSS01_1385353007 SET ONLINE Now the database is up, and we are back to business!

Read more