how to delete properly a Project Server 07 instance

[Robert]

Hello,
I did probably a stupid thing:
I had a "training" instance of PS2007, which was a copy of the "Production"
database.
The "published" database of this training instance seemed corrupted, so I
deleted manually in Enterprise Manager this Published DB and the 3 others:
Draft, Reporting, and Archive.
After that I tried to delete the site in the Manage Project Web Access Sites
page of Shared Services Administration. And I tried to create another one.
But after 3 hours the Status is still "Waiting for resources" and in the
Windows Event viewer (Application) I have hundreds of red errors like:

"GetLanguageInfo failed for PWA site 56ed7426-71b4-44ed-963d-fa64557741ed
Exception:
System.Data.SqlClient.SqlException: Impossible to open the database wanted
in the connection 'ProjectServerBis_Published'. Connexion failure."

NB : 'ProjectServerBis_Published' is the name of the database I deleted
previously...
How can I get out of this trap ?
Need help!

Thanks in advance

 

[Gary L. Chefetz [MVP]]

Robert:

Do you have database backups that you can restore? The way to do this is the
opposite way around, delete the site, then the databases.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com