migration of database

[Lynn]

Hi,
how can i migrate the project server database from server1 to server2?
thanks

 

[Lynn]

any advise?

 

[Dale Howard [MVP]]

Lynn --

Using the SQL Server Enterprise Manager tool, back up the Project Server
database on server1 and restore it to an existing database on server2. Hope
this helps.

 

[Lynn]

do i need to change any configuration on the Project server?

 

[Dale Howard [MVP]]

Lynn --

What are you attempting to do? Is server2 another instance of Project
Server, for example?

 

[Lynn]

i need to consolidate all databases to server2. therefore need to move the
project database from server1 to server2.
do i need to change any configuration on the Project server?

 

[Dale Howard [MVP]]

Lynn --

Is your Project Server software installed on server2?

 

[Lynn]

nope.
Project Server software is installed on server1 and SQL server installed on
server2

 

[Dale Howard [MVP]]

Lynn --

You can use the EditSite software to create the site on server2.