Skip to content
ProjectControls.com
Oracle Primavera - PM6

P6 dbase backup

In the Open Standard
Ahmed SeddikMember for 20 years 10 months
Created
5
1
0
I make dbase backup by using SQL Server Management Studio Express , when restore this backup at another pc it fail to open how can I solve this problem
Save Follow Follow forum Report
Reply New topic

5 replies

Oldest first
  1. 0
    Arnold Puy ·
    #1
    Hi Ahmed,

    Did you specify the source & location of backup sets to restore? Make sure that you choose from device instead of from database.
    Report
  2. 0
    Dieter Wambach ·
    #2
    Ahmed
    I assume this is an item of the SQL-Server. Did you synchronize Privuser and pubuser? Without synchronization SQL-Server doesn’t accept restored data from different servers.
    Regards
    Dieter
    Report
  3. 0
    Ahmed Seddik ·
    #3
    I need to use the backup at another server
    Report
  4. 0
    Duy Huynh ·
    #4
    Verify the following after you restored the db into the new server (login to MS SQL management studio first):
    - Are there ’privuser’ and ’pubuser’ created as log in name for the server (under: /Security/Logins)? If no create this two.

    - Next, after the two users above available, make a "New Query" like below:

    exec sp_change_users_login ’Update_One’,’privuser’,’privuser’
    exec sp_change_users_login ’Update_One’,’pubuser’,’pubuser’
    go

    This will update privuser and pubuser of the server into the database.

    Hope this help
    Report
  5. 0
    Duy Huynh ·
    #5
    Sorry, before that two lines in the query, you need to specify:

    use [pmdb$primavera] -- change it to your actual P6 database name as needed.
    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?