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.

Restore Database

5 replies [Last post]
Wed, 2017-03-01 13:24
Mohamed Galal
User offline. Last seen 7 years 8 weeks ago. Offline
Joined: 12 Sep 2011
Posts: 4
Groups: None

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,

4638
untitledx.jpg

Top

Replies

Thu, 2017-03-02 13:36
#1
Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

hope it worked 

Top
Wed, 2017-03-01 14:06
#2
Mohamed Galal
User offline. Last seen 7 years 8 weeks ago. Offline
Joined: 12 Sep 2011
Posts: 4
Groups: None

Thanks Alot Dear.

Top
Wed, 2017-03-01 13:41
#3
Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None
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\BackupRight 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 IMPORTANTAfter 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 DATABASE1. 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.   
Top
Wed, 2017-03-01 13:34
#4
Mohamed Galal
User offline. Last seen 7 years 8 weeks ago. Offline
Joined: 12 Sep 2011
Posts: 4
Groups: None

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,

Top
Wed, 2017-03-01 13:28
#5
Zoltan Palffy
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

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

Top