How to delete all data from project server

[Anum Imam]

Hi
Well I have bulk of projects in my project server ,and i want to delete all
data associated with those projects ,simply want my project server to give
impression that it is freshly installed.
I have used Project Server cleaner tool but it cant help me in deleting to
do lists.and its really hectic to delete every list individually.
Can any one please help me

 

[Gaurav Wason]

Anum,

Use setupdb.cmd that came with project server cd. That will help you clean
the database (clean project server) do make a copy of Enterprise Global and
Enterprise Resource Pool. Let me know if this helps.

 

[Gary L. Chefetz [MVP]]

One note about Gaurav's advice: You must also run the SQL scripts for your
current Service Pack level otherwise the database won't work. If you're
going to run Setupdb.cmd, do not run it on your production system. Instead
run it on a blank database or create a second instance using EditSite. Then,
backup the blank database and restore it onto production after you verify
that it works. You'll need to backup and restore your custom fields and
views as well. You might also consider writing your own SQL to cleanup what
the cleaner tool leaves behind. Make sure you think through your options
before choosing one.

--

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

 

[Anum Imam]

Thank you so much Gary and Gaurav,well i ill definitly pratice your advices
and notify in case of any problem.
regards
Anum

 

[Anum Imam]

Garry
Can you please tell me how can we know service pack level of current
installation
Thanks in advance