Skip to content
ProjectControls.com
Oracle Primavera - PM6

Regarding Backup & Resotore P6 database

In the Open Standard
Anbin PonnithMember for 17 years 4 months
Created
6
3
0
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
Save Follow Follow forum Report
Reply New topic

6 replies

Oldest first
  1. 0
    Rodel Marasigan ·
    #1
    Anbit,
    Are you using SQL Server Management Studio Express to backup your database? Is your P6 Database standalone or server installation?
    Report
  2. 0
    Anbin Ponnith ·
    #2
    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
    Report
  3. 0
    Rodel Marasigan ·
    #3
    Anbit,
    Try to close P6v7 first before restoring the backup. Make sure that PMDB$Primavera is selected and also the backup file is tick.
    Report
  4. 0
    Anbin Ponnith ·
    #4
    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
    Report
  5. 0
    Rodel Marasigan ·
    #5
    Anbin,
    I suggest giving a call Primavera support again and bringing up the issue as they already assisting on your query.
    Report
  6. 0
    Anbin Ponnith ·
    #6
    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
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?