Archives For Project Server


How to delete orphaned Project Database?

The database specified is already used by another project server. Enter a different server or database name and try again.

atabase_specified_already_used_another_project_server

To delete orphaned Project Database

1. Run: Get-SPDatabase | Select Name

get-spdatabase

2. Identify the database which you want to delete and open SQL Management Studio
3. Select SharePoint ConfigDB and run this query

SELECT OD.ID AS DepID,OD.Name AS DepName, O.ID AS ObID,O.Name AS ObName
FROM Objects AS O
INNER JOIN Dependencies AS D ON O.ID = D.ObjectID
INNER JOIN Objects AS OD ON D.DependantID = OD.ID
WHERE O.Name like ‘ProjectServer_Archive’


remove-project-database

4. Get the GUID ID of the orphaned Project Server Database

GuidID-Delete-Project-Server-Database

5. Copy DepID and open STSADM

stsadm.exe -o deleteconfigurationobject -id <objectId>
stsadm.exe -o deleteconfigurationobject -id B41E07C6-BFE4-4F70-96AB-D4FCB1514A63

stsadm-orphaned-database

6. Perform the steps 3 to 5 for all the orphaned database and create Project Site.