Additional Database in Project 2003

[Angel]

I'm trying to create another database and I'm running into issues because I
can't seem to find any good instructions (please let me know if you know of
any posted on the web). I've done this before but it's been so long that I
can't seem to figure out the correct steps, or maybe just the order of the
steps.

I have found instructions for creating an additional instance for Project
2002 and somehow managed to get it to work in my test environment (only 2
servers) but I'm running into issues in our production environment which is a
multi-server environment (DB Server, App Server, Views Processor/ WSS,
Analysis Server and Session Manager).

The instructions I found say to do the following:
1) Create a new sharepoint services site. I just want a new DB, not a new
Sharepoint Site- do I need to do this? We currently have a production
database and an archive database and I don't remember having to do this
twice. Can I just start at step 4???
2) Extend New Site for Sharepoint.
3) Provision Site for WSS.
4) Create a database.
5) Setup the DB or restore a backup.
6) Add user identities.
7) Use the Edit Site Utility tool to create the new virtual directory.

 

[Ben Howard]

Hi Angel
Create a new database in P2003 to hold the PS data, using the create
database scripts. Also, make sure you run any Service Pack scripts on the
new database. Then use the editsite tool to create the new db.

 

[Angel]

Thank you- I'm making progress.

Question about intsalling SP2a against the new DB: the instructions I have
followed in the past to install SP2a upgrades the entire DB server (the
command line is "upgdb112.cmd server_name") and not the specific DB. If I run
this again, will it have any affect on my other DBs?

 

[James Fraser]

Thank you- I'm making progress.

Question about intsalling SP2a against the new DB: the instructions I have
followed in the past to install SP2a upgrades the entire DB server (the
command line is "upgdb112.cmd server_name") and not the specific DB. If I run
this again, will it have any affect on my other DBs?

I don't have the readme in front of me, but I think that form of the
upgdb112 only upgrades a database with the default name:
ProjectServer. Look in the SP2a installation notes and I think you
will find the command line to upgrade a database with a different
name.


James Fraser

 

[Ben Howard]

James is correct. Read the documentation on the MS website re the
installation of SP2a, and you'll see you can specify the db name alongside
the credentials, and even, if I remember, the server name. It's all there...

 

[Angel]

Thanks. The documentation I had didn't include the full command line. I was
able to upgrade the DB and I'm up and running now. Thanks for your help.