SQL Server – MicroTechPoint

Understanding and preparing for the SharePoint Server Subscription Edition

July 12, 2022March 29, 2023Brian Alderman

SharePoint Server Subscription Edition is the last major release of SharePoint Server on-premises, so if you are currently running an earlier version of SharePoint on-premises, you may want to consider upgrading to SharePoint Server Subscription Edition. This is beneficial to us in a couple of ways. First, you’ll never have to perform a time-consuming, and costly upgrade to obtain new features for the product, and secondly you’ll still receive updates to the product but in a scheduled timely fashion. For more information on this SharePoint Server edition, as well as licensing information, upgrade process, software and hardware requirements, updates, and features and functionality in SharePoint Server Subscription Edition, please visit… Read More

Moving or Renaming a Web Application Content Database

June 2, 2015June 3, 2018Brian Alderman

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

Configuring SQL Server Log Shipping on SharePoint Content Databases

February 7, 2014June 3, 2018Brian Alderman

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