none
Microsoft Project databases migration RRS feed

  • Question

  • Hi,

    We are moving sql server instance containing microsoft project databases from cluster to vm. My question is: Should I backup and restore all databases from cluster to vm or there are specific databases we should move.  If we move all databases, is there any thing worng? We will just will move databases to new server with same sql server version and edition not application.

    Secondly from Microsoft Project application side, do we need to configure something or they will just stop services before restoring the databases and then start Microsoft Project services, will that works?

    Please comment someone who did this migration. Thanks

    Saturday, August 18, 2012 4:12 AM

Answers

  • Hi there,

    Please see this article:

    http://technet.microsoft.com/en-us/library/cc512725.aspx

    High level steps below:

    • Shut down all SharePoint / Project Server application / web server/s
    • Backup ALL farm SQL databases from original SQL Server
    • Restore ALL farm SQL databases to new SQL Server using the same database names
    • Set up all farm services accounts on the new SQL server with the same permissions
    • Script out the delete expired sessions job from the original SQL server and create the job on the new SQL server.
    • Either repoint the DNS / SQL Alias for original SQL Server or if the farm was installed using the original SQL Server name, create a DNS alias for the original SQL Server name and point this to the new SQL Server
    • Configure the new SQL Server: http://technet.microsoft.com/en-us/library/ee662108.aspx
    • Boot up all SharePoint / Project Server web / app server/s
    • Fully test

    Thanks

    Paul


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

    Sunday, August 19, 2012 10:02 PM
    Moderator

All replies

  • Hi,

    Are you only going to move the Microsoft Project Databases meaning the Arhive, Draft, Published, Reporting and Content databases? Or do you also move the SharePoint_Config database. If you going to move the farm you will need to reconfigure the entire farm to take in account you are going to a new sql server. If you going to move only the Microsoft Project Databases you only need to reconfigure the content database and the PWA to point to the new sql server. 

    I should make a back-up of all databases. And before you do the actions stop all the services. If you have the ability first test the migration to be sure everything goes alright.

    This link will give you some more information aswell: http://technet.microsoft.com/en-us/library/dd207290

    Hope it helps.

    With Kind Regards,

    Robin Kruithof


    Technical Consultant EPM

    Saturday, August 18, 2012 9:54 AM
  • Hi there,

    Please see this article:

    http://technet.microsoft.com/en-us/library/cc512725.aspx

    High level steps below:

    • Shut down all SharePoint / Project Server application / web server/s
    • Backup ALL farm SQL databases from original SQL Server
    • Restore ALL farm SQL databases to new SQL Server using the same database names
    • Set up all farm services accounts on the new SQL server with the same permissions
    • Script out the delete expired sessions job from the original SQL server and create the job on the new SQL server.
    • Either repoint the DNS / SQL Alias for original SQL Server or if the farm was installed using the original SQL Server name, create a DNS alias for the original SQL Server name and point this to the new SQL Server
    • Configure the new SQL Server: http://technet.microsoft.com/en-us/library/ee662108.aspx
    • Boot up all SharePoint / Project Server web / app server/s
    • Fully test

    Thanks

    Paul


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

    Sunday, August 19, 2012 10:02 PM
    Moderator