Share via

SQL migration related query for SP 2013

Tanmoy Das 806 Reputation points
2020-12-09T21:08:31.043+00:00

Hi,

1) When we are migrating all sp databases from SQL 2008 to SQL 2014, do we need to stop the SP services in all SP servers or only in the CA server?

2) If only in the CA server, then that will create any outage I believe because all our web sites are hosted in other servers not in the CA server.

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,970 questions
0 comments
Accepted answer
  1. ChelseaWu-MSFT 6,331 Reputation points
    2020-12-10T02:18:03.163+00:00

    You need to stop all services that are related to SharePoint Server and IIS on all SharePoint servers and expect the SharePoint environment to be not accessible during this process.
    Here is a document you can follow for this process: Move all databases in SharePoint Server.

    Another post of discussion that might be helpful: Best practices to migrate to SQL 2014 from SQL 2012 for SharePoint 2013.

    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. **

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.