P6 dbase backup

D
Duy Huynh 👤 Member for 18 years 2 months

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 2 months

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 6 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 2 months

Hi Ahmed,



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

Featured Partner

Top Posters

James Williams
75 posts
Alex Lyaschenko
26 posts
xerxes
0 posts
edwin
0 posts
jhalluk69
0 posts
wilmoahyi
0 posts
Peter Holroyd
51 posts
Robert Guers
1 posts
Jerry Robinson
2 posts
Elyar Safarov
1 posts

Our Partners