Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am a database administrator and I need to move SQL databases from one server to another for enterprise project management, Project Server 2007 installed on WSS 3.0 (both at patch level SP2 + Aug09 CU).

I know how to move databases but I don't know how to re-point the application to the new server.

Can anyone please help me?



share|improve this question
up vote 0 down vote accepted

Move Content databases:

stsadm –o deletecontentdb –url http://yoursiteurl –databasename your_content_db –databaseserver source_SQL_server

stsadm –o addcontentdb –url http://yoursiteurl –databasename your_content_db –databaseserver target_SQL_server

Move Config databases:

stsadm -o deleteconfigdb

stsadm –o setconfigdb -connect –databaseserver target_SQL_server -databasename databasename -farmuser your_farm_sql_account -farmpassword your_farm_sql_password


share|improve this answer
Thank you very much – Manjot Feb 10 '11 at 22:19

If there isn't an INI or a config file or a setting in the application itself, can you cheat and use the HOSTS file on the application server to point the name of the old server to the new server?

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.