Regarding Backup & Resotore P6 database

Submitted by Anbin Ponnith on
Oracle Primavera - PM6

Member for

16 years 4 months
Member for 16 years 4 months
Submitted by Anbin Ponnith on Mon, 2010-06-07 10:22
Permalink

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

Member for

19 years
Member for 19 years
Submitted by Rodel Marasigan on Mon, 2010-06-07 07:43
Permalink

Anbin,

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

Member for

16 years 4 months
Member for 16 years 4 months
Submitted by Anbin Ponnith on Mon, 2010-06-07 07:29
Permalink

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

Member for

19 years
Member for 19 years
Submitted by Rodel Marasigan on Mon, 2010-06-07 06:11
Permalink

Anbit,

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

Member for

16 years 4 months
Member for 16 years 4 months
Submitted by Anbin Ponnith on Mon, 2010-06-07 06:04
Permalink

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

Member for

19 years
Member for 19 years
Submitted by Rodel Marasigan on Mon, 2010-06-07 06:02
Permalink

Anbit,

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