Moving a site collection between content databases (SharePoint 2013 using PowerShell
I have created a new site collection within a SharePoint 2013 web application and want it to use a new content database. After creating the new content database using the New-SPContentDatabase cmdlet I used the Move-SPSite cmdlet: Move-SPSite <URL> –DestinationDatabase…
Enable FILESTREAM and provision a Remote Blob Store
Binary large objects, known as BLOBs, are used to store large binary data such as Office documents and media. By default BLOBs are stored in the content database on the SQL server. Today I am going to enable FILESTREAM on…
Databases exist on servers running SharePoint Foundation
I am working on an installation of SharePoint Foundation that has been reporting the following error for some time: Databases exist on servers running SharePoint Foundation To ensure better performance it is highly recommended to host the databases used by SharePoint…
Using sp_BLITZ to verify SQL configuration
I’m not an SQL expert so I imagine I make a lot of common mistakes when setting up databases. I have just discovered sp_BLITZ by Brent Ozar, which is a set of scripts that will assess the configuration, security, health…
Content databases contain orphaned items
Today when I logged into my SharePoint Central Administration it was warning me that the Health Analyzer had detected some critical issues that require attention. When I looked at the issues this message was among them: After reading the article…
Multiple servers in a three-tier farm configuration
I have been assigned the task of designing and implementing a SharePoint farm that will be used by hundreds of users. Taking redundancy and performance into consideration I have chosen a three-tier topology. This farm will consist of three tiers:…
Planning to install SharePoint 2010
SharePoint isn’t something you can just download and install without a bit of planning. You need to take many things into consideration, such as server configuration, disk space and user accounts. Server configuration The server configuration will depend on requirements. …