P6 dbase backup

D
Duy Huynh 👤 Member for 18 years 1 month

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.

D
Duy Huynh 👤 Member for 18 years 1 month

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

D
Dieter Wambach 👤 Member for 19 years 5 months

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

A
Arnold Puy 👤 Member for 19 years 1 month

Hi Ahmed,



Did you specify the source & location of backup sets to restore? Make sure that you choose from device instead of from database.

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts