Is it possible to change the database server after SharePoint installation

Nur Hossain 282 Reputation points
2023-04-02T18:43:40.3366667+00:00

We have installed SharePoint in Single Farm deployment.

After deployment, we have to change the Database server or SharePoint.

Is it possible to change the database server after SharePoint deployment?

Note: we will restore from the old database server to the new database server but the hostname will be different.

Any Idea?

Thank You

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,259 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,897 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,728 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,582 questions
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,848 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. AllenXu-MSFT 16,876 Reputation points Microsoft Vendor
    2023-04-03T01:50:17.0633333+00:00

    Hi @Nur Hossain ,

    Sure, it is possible to change the database server after SharePoint deployment. In a nutshell, Moving the SharePoint database from one server to another can be achieved with the following steps:

    • Step 1: Stop All SharePoint Services
    • Step 2: Backup & Restore All SharePoint Databases to the new SQL Server
    • Step 3: Point the web application to the new database server by setting up SQL Server connection aliases
    • Step 4: Start All SharePoint Services

    See detailed steps and information in this article: Move all databases in SharePoint Server.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.


  2. AllenXu-MSFT 16,876 Reputation points Microsoft Vendor
    2023-05-04T06:42:34.39+00:00

    Hi @Nur Hossain ,

    May I know do you have any concern on the steps in my previous answer or the result you have tried to it? Feel free to comment here if you still need further assistance. I'm glad to provide further support with you.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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 comments No comments