Additional database
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
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
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
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
Arnold & Rafel thanks for the reply.
I followed the steps of prim54984. I made a backup & restored. But i dont know how to resync. Can someone of ypu guide me how to resync.
Cheers,
Richu
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.
Arnold,
Thanks for the reply.
I would appreciate if u can let me know the steps for creating an additional database.
Cheers,
Richu
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