Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

-

Thanks!

share|improve this question
add comment

2 Answers 2

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

**source: http://sharepointsherpa.com/2008/04/18/sharepoint-2007-move-content-and-configuration-databases/

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

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
add comment

Your Answer

 
discard

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.