Posts

Showing posts from June, 2016

How to downgrade SQL Standard Edition to SQL Express - running SharePoint

How to downgrade SQL Standard Edition to SQL Express - running SharePoint Sometimes mistakes get made, imagine checking an SQL Express installation and finding SQL Standard Edition installed. 
To make this harder to find, the SQL Standard instance was named SQLExpress in Services.
Run a SQL @@version to get the truth.
Overview We'll use a Hyperv replica at the DR site for preparing the recipient server, a clone of production. You could also export the production server and configure as a new virtual machine.
This example SharePoint 2013 installation with SQL2008R2 Standard
Process fist run - without impacting production (takes about an hour)Confirm the production SQL server DNS name is locked in with a static entry. This is to prevent overwrite when starting up your recipient server.On the recipient new server:Configure the recipient server as a new virtual machine on a different subnet from production to prevent name clash.Start the recipient server, set an IP address skip the g…