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.

Regarding Backup & Resotore P6 database

6 replies [Last post]
Mon, 2010-06-07 04:47
Anbin Ponnith
User offline. Last seen 8 years 6 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
Dear All,

I made a back of my data in P6v7 and tried to restore it.But There was a error in restoring..
(message 102 ,level 15,state 1,line 1
incorrect syntax error ’’’.)

With Thanks & Regards,

Anbin Ponnith
Top

Replies

Mon, 2010-06-07 09:22
#1
Anbin Ponnith
User offline. Last seen 8 years 6 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
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
Top
Mon, 2010-06-07 06:43
#2
Rodel Marasigan
User offline. Last seen 3 days 18 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Anbin,
I suggest giving a call Primavera support again and bringing up the issue as they already assisting on your query.
Top
Mon, 2010-06-07 06:29
#3
Anbin Ponnith
User offline. Last seen 8 years 6 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
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
Top
Mon, 2010-06-07 05:11
#4
Rodel Marasigan
User offline. Last seen 3 days 18 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Anbit,
Try to close P6v7 first before restoring the backup. Make sure that PMDB$Primavera is selected and also the backup file is tick.
Top
Mon, 2010-06-07 05:04
#5
Anbin Ponnith
User offline. Last seen 8 years 6 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
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
Top
Mon, 2010-06-07 05:02
#6
Rodel Marasigan
User offline. Last seen 3 days 18 hours ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Anbit,
Are you using SQL Server Management Studio Express to backup your database? Is your P6 Database standalone or server installation?
Top