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.

P6 dbase backup

5 replies [Last post]
Thu, 2008-09-18 20:03
ahmed seddik
User offline. Last seen 17 weeks 4 days ago. Offline
Joined: 12 Dec 2005
Posts: 5
Groups: None
I make dbase backup by using SQL Server Management Studio Express , when restore this backup at another pc it fail to open how can I solve this problem
Top

Replies

Thu, 2008-10-02 03:07
#1
Duy Huynh
User offline. Last seen 14 years 6 weeks ago. Offline
Joined: 24 Apr 2008
Posts: 22
Groups: None
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.
Top
Thu, 2008-10-02 03:04
#2
Duy Huynh
User offline. Last seen 14 years 6 weeks ago. Offline
Joined: 24 Apr 2008
Posts: 22
Groups: None
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
Top
Fri, 2008-09-19 17:19
#3
ahmed seddik
User offline. Last seen 17 weeks 4 days ago. Offline
Joined: 12 Dec 2005
Posts: 5
Groups: None
I need to use the backup at another server
Top
Fri, 2008-09-19 07:07
#4
Dieter Wambach
User offline. Last seen 7 years 1 week ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
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
Top
Fri, 2008-09-19 03:11
#5
Arnold Puy
User offline. Last seen 9 years 12 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Ahmed,

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