none
Change of DB Server in Project Server 2010 RRS feed

  • Question

  • Hi,

    I am working on Project Server 2010.

    I have two servers, one is DB and the other one is application server where Project Server 2010, SharePoint Server 2010 are installed.

    I would like to move the DB server to other new server.

    What is the procedure(steps) to do that? and Will there be any issue occur doing so?

    Please help.


    K.Gokulraj

    Friday, April 11, 2014 2:39 PM

Answers

  • Hello,

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

    • Shutdown the SharePoint / Project Server 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
    • start up SharePoint / Project Server server
    • set up SQL maintenance plans on new target SQL server

    Paul


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

    • Marked as answer by K.Gokulraj Monday, April 14, 2014 3:10 PM
    Friday, April 11, 2014 4:52 PM
    Moderator

All replies

  • Hello,

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

    • Shutdown the SharePoint / Project Server 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
    • start up SharePoint / Project Server server
    • set up SQL maintenance plans on new target SQL server

    Paul


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

    • Marked as answer by K.Gokulraj Monday, April 14, 2014 3:10 PM
    Friday, April 11, 2014 4:52 PM
    Moderator
  • Hi Paul,

    Thanks for your reply.

    Can you send me the steps(how to do that) for the below points?

    • 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
    • start up SharePoint / Project Server server
    • set up SQL maintenance plans on new target SQL server
    • script out the delete expired session SQL job from the source SQL server


    K.Gokulraj

    Monday, April 14, 2014 7:52 AM
  • Hello,

    Your SQL DBA will know how to script out a SQL job (delete expired sessions) then create the job on the target SQL Server - it is very simple. Right click on the job, script job as > create to. Then take that file and load on to the new target SQL server.

    How was the SQL server referenced when you did the farm install? Usually an alias is used.  When you look at servers in the farm in central admin, does it use the actual SQL server machine name or an alias name? Basically what ever you do you need to make sure the SharePoint farm is still using the same SQL Server name - this is why I mentioned repointing alias.

    Start up the SharePoint / Project server serer - this mean boot them up.

    SQL maintenance plans - your SQL DBAs will be able to set these up but see the links: http://technet.microsoft.com/en-us/library/cc973097(v=office.14).aspx & http://pwmather.wordpress.com/2012/09/14/projectserver-optimisations-for-sql-server-and-ps2010-databases-sp2010-msproject/

    Paul 


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

    Monday, April 14, 2014 8:23 AM
    Moderator
  • Thanks for your reply

    K.Gokulraj

    Monday, April 14, 2014 3:08 PM