Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Additional database

7 replies [Last post]
Fri, 2009-09-25 23:00
richu rose
User offline. Last seen 14 weeks 4 days ago. Offline
Joined: 13 Feb 2007
Posts: 63
Groups: None
Hi,

Is it possible in P6 6.0 to have a new database per project.

Richu
Top

Replies

Sat, 2009-10-03 05:16
#1
richu rose
User offline. Last seen 14 weeks 4 days ago. Offline
Joined: 13 Feb 2007
Posts: 63
Groups: None
Arnold,

1. What do you really after, to add a new database or you want to know how to backup and restore database?
I want add a new database.

2. Is your database Backup process is successful?
Yes my database backup was successful.

3 Where is your database come from? Is this the one of your Backup data? Or it came from another computer?
It is one of my backup data.

4. During the process of restoring your Database, is it successful or not?
Restore was successful.

Regards,

Richu
Top
Fri, 2009-10-02 17:02
#2
Arnold Puy
User offline. Last seen 9 years 25 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Thanks Rafael.

Hi Richu,

First of all, I have a few questions to you.

1. What do you really after, to add a new database or you want to know how to backup and restore database?
2. Is your database Backup process is successful?
3 Where is your database come from? Is this the one of your Backup data? Or it came from another computer?
4. During the process of restoring your Database, is it successful or not?

If you can provide me these information then I can tell you what to do.

Regards,

Arnold
Top
Thu, 2009-10-01 11:51
#3
Rafael Davila
User offline. Last seen 2 days 3 hours ago. Offline
Joined: 1 Mar 2004
Posts: 5230
Groups: Spider Project Team
richu

It got to be Arnold or someone else as I do not have P6, all I can tell you we tried P6 but decided not to go with it. Among the few things we explored was the creation of several databases and although not as easy as 123 it was not so difficult.

For re-sync maybe the following can help you:

You will need to use the SQL Server Management Studio in order to get this to work. When you log into the SQL Manager, You select the P6 database. Right click and select: "New Query".

In the right pane you will need to paste the following script:
Exec sp_change_users_login ’Update_one’,’PUBUSER’,’PUBUSER’
Exec sp_change_users_login ’Update_one’,’PRIVUSER’,’PRIVUSER’
and select "Execute" from the menu.

The connection to the priv- and pubuser is reastablished.
Now you will no longer receive the "Bad Public user name & password" error.

Good luck,
Rafael
Top
Thu, 2009-10-01 10:38
#4
richu rose
User offline. Last seen 14 weeks 4 days ago. Offline
Joined: 13 Feb 2007
Posts: 63
Groups: None
Arnold & Rafel thanks for the reply.

I followed the steps of prim54984. I made a backup & restored. But i don’t know how to resync. Can someone of ypu guide me how to resync.

Cheers,

Richu
Top
Sat, 2009-09-26 07:27
#5
Rafael Davila
User offline. Last seen 2 days 3 hours ago. Offline
Joined: 1 Mar 2004
Posts: 5230
Groups: Spider Project Team
http://primavera.zxlm.cn/kb/prim54984

Create a backup and restore to a different name, clear all fields and use this as your template for your new databases.

Good when close to database limits.
Top
Sat, 2009-09-26 05:08
#6
richu rose
User offline. Last seen 14 weeks 4 days ago. Offline
Joined: 13 Feb 2007
Posts: 63
Groups: None
Arnold,

Thanks for the reply.

I would appreciate if u can let me know the steps for creating an additional database.

Cheers,

Richu
Top
Sat, 2009-09-26 02:12
#7
Arnold Puy
User offline. Last seen 9 years 25 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Richu,

Yes you can. What you need only is your "CD1 & License". However, in my opinion, it is not advisable for you to create too many databases. Say for example, if you have 10 Projects so, you need to create 10 Databases.

In my experienced, we have Two Projects but I have only Two Databases, one for PMDB$PRIMAVERA & the other one ARNOLD_PUY.

Regards,

Arnold

Top