Regarding Backup & Resotore P6 database

A
Anbin Ponnith 👤 Member for 17 years

Dear Rodel,



Actually there is a solution displayed there..





EXEC sp_change_users_login ‘Update_One’, ‘pubuser’, ‘pubuser’

EXEC sp_change_users_login ‘Update_One’, ‘privuser’, ‘privuser’



I tried this..even though I am getting error..



With Thanks & regards,



Anbin Ponnith

R
Rodel Marasigan 👤 Member for 19 years 7 months

Anbin,

I suggest giving a call Primavera support again and bringing up the issue as they already assisting on your query.

A
Anbin Ponnith 👤 Member for 17 years

Dear Rodel,



I have done the back & restore asper the details given in the primavera online interaction point queery no:54984.



I could restore and configure it as a separate name.eg.My name.



I could not syconrnoze it with the PMDB database.



Also I am not able to understand the last line commands given in it.





With Thanks & Regards,



Anbin Ponnith

R
Rodel Marasigan 👤 Member for 19 years 7 months

Anbit,

Try to close P6v7 first before restoring the backup. Make sure that PMDB$Primavera is selected and also the backup file is tick.

A
Anbin Ponnith 👤 Member for 17 years

Dear Rodel,



I am using SQL Server Managemnet Studio Express to backup mu database.



Also I my P6 database is Standalone..





With Thanks & Regards,



Anbin Ponnith

R
Rodel Marasigan 👤 Member for 19 years 7 months

Anbit,

Are you using SQL Server Management Studio Express to backup your database? Is your P6 Database standalone or server installation?

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