none
Changing DB server for EPM RRS feed

  • Question

  • Hi

    I am working with PS 2013.

    We have a App, FE web server and a DB server in the Farm. Now the task is to replace the existing DB server with the new DB server.

    Can someone suggest how to swap DB server?

    If the new DB server is introduced, the SQL instance. IP address would be different which the applications have been pointing so far.

    Do we need to update anything from applications side.

    Pls suggest.

    Sunday, August 31, 2014 7:39 AM

Answers

  • Hello,

    The high-level steps are below. I would test this on a test farm first:

    • Shutdown the SharePoint / Project Server / Workflow Servers
    • Backup ALL of the Farm databases from source SQL server
    • Restore ALL of the farm databases to the target SQL Server using the same names
    • set up all of the logins on the new target SQL server
    • script out the delete expired session SQL job from the source SQL server
    • create the delete expired session jobs on the target SQL server
    • repoint SQL Server Alias / DNS alias from source SQL server to target SQL Server for SharePoint and Workflow
    • start up SharePoint / Project Server / Workflow servers
    • set up SQL maintenance plans on new target SQL server

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Sunday, August 31, 2014 4:00 PM
    Moderator

All replies

  • Hi,

    the easiest way would be to add an SQL alias on the SharePoint and the SQL Server(including SSAS).

    However you might come across issues with excel reports if you are editing them on the local machines as it still holds the old server name in the connection string. (Add a SQL alias on the machine you are editing the report and it will work like a charm)


    Cheers! Happy troubleshooting !!! Dinesh S. Rai - MSFT Enterprise Project Management Please click Mark As Answer; if a post solves your problem or Vote As Helpful if a post has been useful to you. This can be beneficial to other community members reading the thread.

    Sunday, August 31, 2014 2:56 PM
    Moderator
  • Hello,

    The high-level steps are below. I would test this on a test farm first:

    • Shutdown the SharePoint / Project Server / Workflow Servers
    • Backup ALL of the Farm databases from source SQL server
    • Restore ALL of the farm databases to the target SQL Server using the same names
    • set up all of the logins on the new target SQL server
    • script out the delete expired session SQL job from the source SQL server
    • create the delete expired session jobs on the target SQL server
    • repoint SQL Server Alias / DNS alias from source SQL server to target SQL Server for SharePoint and Workflow
    • start up SharePoint / Project Server / Workflow servers
    • set up SQL maintenance plans on new target SQL server

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    Sunday, August 31, 2014 4:00 PM
    Moderator