New Database Server.....HELP!!!

[tcs]

Hello. I hope someone can help. I am trying to bring a
new SQL database server online over the Thanksgiving
holiday with a name different than that of the current DB
server.

I have found articles on how to migrate data from Project
Central to Project Server 2002, but am not finding
anything on how to bring data over to a new SQL server on
a new physical server, while maintaining everything and
re-targeting the Project Server 2002 application install
(on yet a third, separate server).

Can ANYONE provide help here? Is the answer simply to
backup the PS database, uninstall / reinstall the Project
Server 2002 and Sharepoint applications using the new DB
server, then import the data from the prior installation
into the new instance on the new DB Server???

HELP!!!

 

[Gary L. Chefetz]

tcs:

Here are the high-level steps involved:

1. Backup the existing database using a sql backup. (Truncate your log files
first.)
2. Run the setupdb.cmd file against the new database server to setup a blank
database shell on the new server.
3. Restore the original database backup on the new server on top of the new
database just created.
4. Harvest the passwords for the MSProjectUser and MSProjectServerUser
accounts from the Project server machine registry. Change the passwords for
these accounts through Enterprise manager on the new SQL box.
5. Download and use the Site Editor tool to point your old site to the new
database server.

That will move your Project Server database, but you may also have
SharePoint to contend with.