Restored Project Server 2003 - No WSS sites associated

[Mick]

All,

Just got finished the final steps (or at least I thought were the final
steps) in restoring a Project Server 2003 to a physically new server.

Everything looks great in PWA and Project Pro...except for the WSS portion.
There are no WSS sites associated with my projects? When I look under
"Manage Sharepoint sites", there are no sites under site address column with
the exception of the Public Documents.

Any idea of how I can easily "RE-associate" the sites on the new server with
the existing projects. BTW - The restored WSS sites work fine on the new
server...but they have simply lost the association with the projects?

Any ideas would be greatly appreciated.

NOTE: Anyone who reads this message who has a production MS Project 2003
Server and an MSDN subscription, please take my advice: Aquire a PC with a
decent amount of disk space, a perform a test restore of your MS Project 2K3
Server enviornment...documenting every step....and make sure it is included
in your organizations Disaster Recovery Plan. Best of all....you can use the
restored server for testing.

Mick

 

[FaisalM]

Try WSSMigr.exe & STSAdm.exe to backup & restore sites.

Download WSSMigr at:
http://www.microsoft.com/downloads/...f5-2adb-43d8-8a33-9b34d2ebbba7&displaylang=en

Look for STSAdm.exe under this path.
\Program Files\Common Files\Microsoft Shared\Web Server Extensions\60\BIN



--
FaisalM
http://www.FaisalMasood.com/

My Project Blog
http://www.faisalmasood.com/blog/msproject

My Sharepoint Blog
http://www.faisalmasood.com/blog/sharepoint

 

[Mick]

Faisal,

Thanks for the quick response. Is this the only way to achieve the desired
results?
Did I miss a step somewhere? This is critical that I know this...as I am
creating a comprehensive Restore Manual for all users of MS Project Server.
The ones issued by MS leave a lot to be desired.

Thanks again.

Mike

 

[Mick]

In addition...the reason I asked the previous question is that all of the sites are available and working on my new server. In other words...I can open the migrated WSS sites by using thier URL. Ex- http://<new server's name/sites/projectserver_107. They are just not "linked" or "associated" with my restored projects within PWA.

Your suggestion sounds like I have to backup the WSS sites separately?

 

[Mick]

Faisal,

Found a Work-A-ROUND! This is what I ended up doing....

Within the ADMIN \ Manage Windows Sharepoint Services \ Manage Sharepoint Sites \

I simply highlighted an individual Project ID, and clicked "Create Site" It automatically linked me to the restored site.

Worked for me.

Thanks again for your repsonse.
In addition...the reason I asked the previous question is that all of the sites are available and working on my new server. In other words...I can open the migrated WSS sites by using thier URL. Ex- http://<new server's name/sites/projectserver_107. They are just not "linked" or "associated" with my restored projects within PWA.

Your suggestion sounds like I have to backup the WSS sites separately?

 

[FaisalM]

You don't have to backup sites individualy.
Have you tried 'Edit Site Address' & then Synchronize under PWA > Admin >
Manage Windows SharePoint Services > Manage SharePoint sites?

Better look at this article. It will give you a better idea.

How to move the databases that are used by Windows SharePoint Services and
by Project Server 2003 to a computer that is running SQL Server
http://support.microsoft.com/kb/905386

--
FaisalM
http://www.FaisalMasood.com/

My Project Blog
http://www.faisalmasood.com/blog/msproject

My Sharepoint Blog
http://www.faisalmasood.com/blog/sharepoint

 

[FaisalM]

Did it use old site in the creation process & saved existing documents,
issues, risks etc or it created new site without saving old sites data?

--
FaisalM
http://www.FaisalMasood.com/

My Project Blog
http://www.faisalmasood.com/blog/msproject

My Sharepoint Blog
http://www.faisalmasood.com/blog/sharepoint

 

[Mick]

Yes it did use the old site.

All of the lists, documents, etc are fully in tact.

 

[Mick]

NA...you don't have to do that.

Just hilight each individual project and click create site...in seconds they
are re-associated....thanks again.

 

[FaisalM]

Good to hear that.

I'm thinking for small # of sites (projects) one can do that. What if
someone have hundreds of projects sites?

I think in that case http://support.microsoft.com/kb/905386 this article
would be helpful. But anyway I'd do the testing in development environment.

Thanks.

--
FaisalM
http://www.FaisalMasood.com/

My Project Blog
http://www.faisalmasood.com/blog/msproject

My Sharepoint Blog
http://www.faisalmasood.com/blog/sharepoint

 

[Darbha]

I am new to Project Server 2003 & Project Professional 2003.
We are testing the EPM environment
with Win 2003 Server, IIS, SQL , WSS, Project Server 2003 & Project
Professional 2003.
Question: Can u help me (Step by Step) How to Backup and Restore WSS,
Project Server 2003 & Project Professional 2003 So that Production Server is
restored
100% in Test Server

Any Ideas! Please Help
Darbha

 

[Darbha]

I am new to Project Server 2003 & Project Professional 2003.
We are testing the EPM environment
with Win 2003 Server, IIS, SQL , WSS, Project Server 2003 & Project
Professional 2003.
Question: Can u help me (Step by Step) How to Backup and Restore WSS,
Project Server 2003 & Project Professional 2003 So that Production Server is
restored
100% in Test Server

Any Ideas! Please Help
Darbha