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

Closed Web Parts in SharePoint – How to Find, Restore and Delete?

Closed Web Parts? What are they? When users don’t need a particular web part on the page, they click on Edit drop down from the Web Part Menu, and choose “Close” instead of Delete. They prefer Close rather than Delete which is obvious! Technically, When you close a Web Part, It doesn’t…

Read more

Drive Space Monitoring using PowerShell Script

In SharePoint servers monitoring disk space is a common administrator task. Because, SharePoint servers may run out of disk space from SharePoint, IIS Logs, SQL Server transaction logs, or even from SharePoint content (If you don’t have Quotas enabled!) There are a lot of first-party, third-party utilities available, such as SCOM to…

Read more

Stop and Start SharePoint 2010 Services

In my Laptop with Windows 7, I’ve SharePoint 2010 Installed for my tryouts. I use it whenever I’m out of network connectivity. Problem is: Not quite frequently I use SharePoint from my laptop, but SharePoint services start automatically when I turn on my laptop and eating up my resources especially RAM. (SharePoint…

Read more

Delete All Items from List or Library using PowerShell

At times, we may have to delete all items from SharePoint list or library. We can get it done by going to “Manage Content and Structure” option as in my another article How to Remove All responses from SharePoint Survey There may be situations, where we’ve to delete all items from SharePoint…

Read more

How to Create an SQL Server Alias for SharePoint?

In My SQL Server best practices for SharePoint, I wrote a point on SQL Server Alias. Allow me to elaborate on that by going a little deep on configuring SQL alias for SharePoint. Why do We need SQL Alias for SharePoint? When installing SharePoint, you’ll be prompted to enter the SQL Server…

Read more