Connect to Office 365 SharePoint Online using PowerShell
Here is how to connect to your SharePoint Online environment using PowerShell and the Connect-SPOService cmdlet: Download the SharePoint Online Management Shell Run the SharePoint Online Management Shell (there will be an icon in the Start Menu) Connect using the…
Export-SPWeb error – there is not enough space on the disk
I am exporting a document library from a SharePoint 2013 site using the Export-SPWeb PowerShell cmdlet but after a few minutes it generates the following error: Export-SPWeb : There is not enough space on the disk. The document library is…
SharePoint 2016 – The upgraded database schema doesn’t match the TargetSchema
I have not had much exposure to SharePoint 2016 yet and have only just applied my first cumulative update. Unfortunately it didn’t go well and failed. Here is what I pulled out of the log file: ERR Failed to…
SharePoint 2013 – “An unexpected error has occurred” when configuring incoming E-Mail settings
While trying to enable incoming E-mail settings for a document library within SharePoint 2013 I received the following error: An unexpected error has occurred. I used the Merge-SPLogFile PowerShell cmdlet to collate all log entries relating to the correlation ID. The…
Using the Merge-SPLogFile cmdlet
The Merge-SPLogFile cmdlet can be a real time saver if you need to search the SharePoint logs and there are multiple servers in the farm. I regularly use it to search for a specific correlation ID and then open the…
Rename a Service Application’s database using PowerShell
While setting up a SharePoint 2013 DR environment I needed to script the renaming of databases used by service applications. Utilising the Get-SPServiceApplication cmdlet I was able to achieve this with just three lines: $sa = Get-SPServiceApplication -Name “Managed Metadata…
SharePoint 2013 – create a new eDiscovery Centre
An eDiscovery site can be used to search for, preserve and export content in SharePoint, Exchange or Skype for Business (formerly known as Lync). To create a new site collection for eDiscovery just follow these simple steps: Log in to…
Excel Services is not currently able to load workbooks
If you find that Excel Services is not able to load workbooks in your SharePoint site then this may be due to insufficient permissions. You may also see the following error in your logs: System.Data.SqlClient.SqlException: Cannot open database “SP2013_Content_Portal” required…
Recreate the sitemap in the configuration database
I have just installed the latest cumulative update on the servers in my SharePoint 2013 DR farm. Unfortunately, after installing the binaries, running the products configuration wizard failed. After looking through the logs it became evident that the site map…
Backup a service application using PowerShell
If you are making changes to a service application and need to take a backup beforehand this can be done quickly using the Backup-SPFarm cmdlet. Here is an example of how to backup the Managed Metadata service application and proxy:…