SQL Databases

[Laura]

How do I find or look up the names of the Databases that we are using for PS
2007?

 

[Marc Soester [MVP]]

Hi Laura,

the best idea is to check the SQL database itself. Likely that the DB are
called something like, Project Server draft, Project Server published,
project server archive and proejct server reporting db
Hope this helps

 

[Laura]

Is there any way through "Server Settings" in PWA?

 

[Ben Howard]

Alternatively, open up WSS Central Admin, click on the SSP that hosts the pwa
instances you are interested in, highlight the instance and click the down
arrow to view the instance information. The relevant DBs will be shown on
the screen. The content DB is associated with the SSP, again use WSS Central
admin to find this.
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

 

[Marc Soester [MVP]]

Hi Laura,

sorry the server setting doesnt tell you the db names. It will only tell you
the Analysis Server name for the olap cubes.
Sorry