How to move Project server 2007 database to another SQL Server

• willtwc

  Ten Centuries

  Points: 1099

  More actions

  January 12, 2010 at 5:03 pm

  #141603

  Is there a way to move all the Project server 2007 databases to another SQL Server? Solutions I read about involved backing up and restoring the server through SSPS.

  Can I detach and attach followed by pointing the Project server to the new SQL Server?

• willtwc

  Ten Centuries

  Points: 1099

  More actions

  January 14, 2010 at 11:38 pm

  #1104063

  I tried the solution found in the link below but I could not bring up the screen to remove the server farm.

  The wizard goes through 10 out of 10 steps and exited.

  http://lkar.blogspot.com/2008/05/moving-moss-project-server-2007.html