When creating a web application in SharePoint 2013 it will communicate with SQL Server to create the supporting content database. Depending on what steps are used to create the Web Apps it sometimes creates the SharePoint database with a not-so-‘friendly’ database name and it may contain a ginormous GUID, (which I pronounce Goo-id) as part of the database name. When working with these databases it can become challenging to specify the name of the database within PowerShell or SQL Server so you’ll want to rename the database to a more user-friendly name. You may also decide you need to move the database to a different location on your hard drives, but you don’t want to recreate the Web… Read More
Continue ReadingSharePoint Windows Explorer Operations Perform Very Slowly
The ability to upload files into SharePoint using the Windows Explorer window makes the migration of content into SharePoint significantly easier. The Windows Explorer mode option in SharePoint is also very beneficial if you want to move content from one location to another location in SharePoint. However, if you have not made one quick configuration change to Internet Explorer the time it takes to perform the upload, copy, or move within SharePoint is horribly slow. You can follow these steps to significantly decrease the time necessary for these operations: In Internet Explorer, open the Tools menu and click Internet Options Click the Connections tab Click the LAN Settings button Uncheck the “Automatically detect settings” box Click OK until all… Read More
Continue ReadingConfiguring SQL Server Log Shipping on SharePoint Content Databases
Implementing data redundancy is one of the most effective ways to avoid data loss in any application. Although this article discusses configuring redundancy for SharePoint content stored in SQL Server by configuring SQL Server log shipping, redundancy should not be limited to only data redundancy. Any possible single point of failure, including hard drives, cables, and DNS or IIS entries should be taken into consideration to ensure you are able to quickly recover from what could be a disaster. There are several methods to choose from when determining the type of data redundancy you need to ensure business continuity. A few of these methods include; SQL Server clustering, database mirroring,… Read More
Continue Reading