Share via

Upgrading SQL from 2008 to 2014 for a SharePoint 2013 farm

Tanmoy Das 806 Reputation points
2020-12-04T01:38:20.053+00:00

Hi,

I have a sp 2013 farm with SQL 2008. We are planning to migrate the SQL from 2008 to SQL 2014.

I believe, from SP side not much to do except changing the SQL alias that we are using in each and every SharePoint server.

My question is

1) When the SQL team will copy the database do I need to stop the IIS, Timer and Admin services.

We want to reduce the outage as much as possible that is why I am asking. Stopping the services will cause an outage

SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,900 questions
0 comments
Accepted answer
  1. JoyZ 18,056 Reputation points
    2020-12-04T06:56:47.23+00:00

    Hi anonymous user,

    From the process as outlined by Microsoft, it is necessary to stop all services that are related to SharePoint Server and Internet Information Services (IIS) in SharePoint server.

    We suggest you do this on non-working days to avoid unnecessary issues caused by server shutdown.

    For detailed information, please refer to:

    https://learn.microsoft.com/en-us/SharePoint/administration/move-all-databases?redirectedfrom=MSDN#move-all-databases

    If an Answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Trevor Seward 11,696 Reputation points
    2020-12-04T23:54:53.857+00:00

    You shouldn't copy the databases as copies will be out of sync with production. Have a planned period of downtime where you can perform all the necessary steps to complete the database migration.

    You don't need to use SharePoint cmdlets to set up the AOAG. You do need to use cliconfg.exe on each SharePoint Server to create an alias that points to the new AOAG Listener. Your DBAs should be adding the applicable databases to the AOAG (i.e. do not add Usage as it does not support high availability).