Skip to content
ProjectControls.com
Oracle Primavera - PM6

Restore database PM6 to other computers

In the Open Standard
Tommy NugMember for 18 years 11 months
Created
4
2
0
Hello ALL,

I am not sure if i can find how to restore a database from one computer to the others or not:

I follow back-up steps on my computer:
1. Open SQL Server Management Studio Express
2. Name: sa, pss: Prima123Vera
3. Select Database/pmdb$primavera, right click to backup (type: full, expire after 0 days)
4. Save a backup file with extension *.bak

The problem is, i can use this file to restore on this computer but can not restore that file in another computer. Why cant I?
Save Follow Follow forum Report
Reply New topic

4 replies

Oldest first
  1. 0
    Rodel Marasigan ·
    #1
    Tommy,
    The back-up file recognized the original server so you cannot restore it to other computer. The best way is back-up to xer. You can use one xer for all by selecting the highest level of enterprise.
    Another way is copy across all data from MSSQL folder. You need to copy the original to the safe location incase it did not work on your copy from other computer so you can copy it back.
    Report
  2. 0
    Tommy Nug ·
    #2
    Thanks Rodel,

    Can we change the user name of destination sever? I believe the reason we can not restore is because it does not match with the original name of back up file. Am i correct?
    Report
  3. 0
    Tommy Nug ·
    #3
    Thanks Rodel,

    Can we change the user name of destination sever? I believe the reason we can not restore is because it does not match with the original name of back up file. Am i correct?
    Report
  4. 0
    Rodel Marasigan ·
    #4
    Tommy,
    It recognise the server name and not the user because users can be SQL authentication not just window authentication. For SQL authentication you can use the default which is privuser (usersname and password)
    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?