locked
Move all databases to a new SQL server RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    are there any step by step guide to move all databases from a Project Server 2013 to a new SQL server?

    We have Workflows, ServiceBus, Search Service, Cache Service, MySites, Sharepoint DBs and Project Server DBs.  The old SQL server will be removed and we do not have a clear vision of what order to follow.

    Thanks


    • Edited by Ximet Tuesday, July 22, 2014 7:31 AM
    Tuesday, July 22, 2014 7:29 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    • Marked as answer by Ximet Tuesday, July 22, 2014 11:37 AM
    Tuesday, July 22, 2014 8:34 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    • Marked as answer by Ximet Tuesday, July 22, 2014 11:37 AM
    Tuesday, July 22, 2014 8:34 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    In our case we do not have a test farm so it will be done directly with the expected downtime.

    Thanks a lot for your help

    Tuesday, July 22, 2014 11:06 AM