P6 dbase backup
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
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.
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
I need to use the backup at another server
Ahmed
I assume this is an item of the SQL-Server. Did you synchronize Privuser and pubuser? Without synchronization SQL-Server doesnt accept restored data from different servers.
Regards
Dieter
Hi Ahmed,
Did you specify the source & location of backup sets to restore? Make sure that you choose from device instead of from database.