How do you re-initialize project databases ?

[AArteagaK]

We want to start from a clean database after having failures with Project
Server 2007. Basically we did the infrastructure upgrade wrong and had to
reinstall everything again, but the databases were not changed, now we can
save a project but when we publish it, we get the following error:

<detail><errinfo><general><class name="Queue"><error id="26005"
name="GeneralQueueCorrelationBlocked"
uid="2167440a-dc88-4aa3-8c26-4262df7b6bdc"
CorrelationUID="d6f24c03-c8d3-4822-9894-f9bd63e91496"
JobUID="aea7e6bc-edab-4437-abe9-9b5a7d960f07"
JobType="ACProjectSave"/></class><class name="Correlation blocked for
d6f24c03-c8d3-4822-9894-f9bd63e91496"><error id="26005"
name="GeneralQueueCorrelationBlocked"
uid="cca670db-c9c0-4e12-bdae-c40e3c4bc02f" CorrelationUID="" JobUID=""
JobType=""/></class></general></errinfo></detail>

After many hours trying to find out more about it, we decided that if
there's a way to re-initialize the databases to the original, new
installation state, we can bring save all the projects back in and publish
them, etc.

Any help will be appreciated

Thanks

 

[Ben Howard]

The easiest way is probably to remove the instance from the SSP (delete it),
then delete the four Project Server DBs using SQL Management Studio, and then
create a new instance, with the same name.