Skip to content
ProjectControls.com
Planning, Scheduling & Programming Discussion

Restore Database

In the Open Standard
Mohamed GalalMember for 15 years 1 month
Created
5
3
0

Dears,

I have a problem with my p6 stand alone version, I had took abackup file before chaning my windows and when i set up p6 again i tried tor restore my databse but it failed and i got the attached message.

Please advise because i lost  a three years work.

Thanks,

Save Follow Follow forum Report
Reply New topic

5 replies

Oldest first
  1. 0
    Zoltan Palffy ·
    #1

    what do you mean you changed

    what do you mean you changed your windows you udated the version of windows ?

    also can you type the error message the screen shot is too small to read

    thanks

    Report
  2. 0
    Mohamed Galal ·
    #2

    I were working in windows 7

    I were working in windows 7 and i changed it to windows 8.1, so i setup primavera 6 and when i tried to restore the backup file it failed.

    can you explain how to restore database on microsoft SQL 2005.

    Regards,

    Report
  3. 0
    Zoltan Palffy ·
    #3

    If using P6 Standalone with a

    If using P6 Standalone with a SQL Express Database:
    • The default Server Name is <machine name>\primavera.
    • The default login (using SQL Authentication) is:
     Username: SA
     Password: Prima123Vera
    • The default destination folder for the backup file is C:\Program Files\MSSQL\Primavera\MSSQL.1\MSSQL\Backup
    Right click on "Databases" and choose "Restore Database".
    Specify the new database name in the "To database" box. Select "From device" and browse tothe location of the .BAK (backup) file. Check the "Restore" box to select the backup set to be restored.
     
    If moving the database to a different computer verify the path to the data file is correct.
    Click on the Options Page and verify the Restore path matches the path to the current data files folder.
     
    VERY IMPORTANT
    After restoring a Primavera database you must resync the following database schema users: privuser and pubuser. The Resynch command resyncronizes the database with the login ID's privuser and pubuser on the server.
    To resynch the privuser and pubuser, run this query against the newly restored database:
     
    EXEC sp_change_users_login 'Update_One', 'pubuser', 'pubuser'
    EXEC sp_change_users_login 'Update_One', 'privuser', 'privuser'
     
    HOW TO RESYNC the DATABASE
    1. Launch SQL Server Management Studio from Start/Programs/Microsoft SQL Server 2005/SQL Server Management Studio (Express)
    2. Connect with Windows or SQL Authentication.
    3. Expand the "Databases" folder on the left and highlight the database name.
    4. Click the "New Query" button at the top left.
    5. Paste the resync script in the blank window on the right-hand side.
    6. Be sure that the correct database name is shown in the drop-down box to the left of the execute button.
    7. Richt Click Execute.
     
     
     
    Report
  4. 0
    Mohamed Galal ·
    #4

    Thanks Alot Dear.

    Thanks Alot Dear.

    Report
  5. 0
    Zoltan Palffy ·
    #5

    hope it worked

    hope it worked 

    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?