moving Project Server to a new SQL server box

[Jim]

I have an environment where SQL Server currently lives on a W2k Server
machine. Project Server and PWA are currently the only SQL apps running
onthis machine. We are about to embark on a migration from this machine to a
brand new Win 2003 machine. Here's a snapshot of the migration:

Dump the Project SQL databases to disk and turn off the SQL Server services
on the current PWA/PS machine

- Build out the new SQL Server box. The OS will move from Win2K to Win2003.
SQL server remains at SQL 2000 standard edition. Install Project Server and
configure PWA on the new machine.

- Load the db dumps from the old PS machine to the new PS machine. I
understand the database sizes will have to be the same.

If anyone has any thoughts or pointers from their experiences, I'd love to
hear them.

Many thanks.

Jim

 

[Gary L. Chefetz \(MVP\)]

Are you moving a Project Server 2002 installation?

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

-

 

[Jim]

No. The existing server is a PS 2003 server. All we are doing is replacing
the hardware and upgrading the OS from W2K Server to W03 standard server.

 

[Gary L. Chefetz \(MVP\)]

Jim:

Then you should need only to transfer the databases and use the Edit Site
tool to change your pointers.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

-