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.

Enterprise Database backup & restore

4 replies [Last post]
Sun, 2007-10-28 09:07
Luca Basile
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
Hi
Can any one help me and give me a step b step guide line on how to backup and restore the P5 database?

Cheers
L
Top

Replies

Tue, 2007-10-30 00:56
#1
K D
User offline. Last seen 15 years 28 weeks ago. Offline
Joined: 25 Sep 2007
Posts: 247
Groups: None
Hi Andrew.
This backup solution will need a SQL skill to reattach the database. I think not much people know it.
So we should just use it in case our OS crashed, and we can copy those file in DOS environment.

Regards
Top
Mon, 2007-10-29 16:50
#2
Andrew Podolny
User offline. Last seen 41 weeks 5 days ago. Offline
Joined: 16 Nov 2004
Posts: 130
Groups: Petro-Chem / Oil & Gas
Another method with MSDE SQL & Primavera 5 is follow. Close Primavera 5.
Goto Start->Run..
In window type services.msc ENTER
Locate SQL Server (PRIMAVERA) right click and select stop.
Don’t close the services window.
Then open My Computer and browse for path

C:\Program Files\Microsoft SQL Server\MSSQL$PRIMAVERA\Data
Copy databases:
pmdb$primavera_DAT
pmdb$primavera_LOG
mmdb$primavera_DAT
mmdb$primavera_LOG
to a secure place.
* Note - the path and names may vary based on your setup configuration

Start SQL Server (PRIMAVERA) again by right click and select Start. Close Services window.
If you are already upgraded to Primavera 6 - the things are much easier in SQL Server Management Studio Express environment.

Regards,
Andrew

Top
Sun, 2007-10-28 22:28
#3
liu yi
User offline. Last seen 15 years 25 weeks ago. Offline
Joined: 28 Oct 2007
Posts: 17
Groups: Civil Engineering
thanks a lot .I am learning from you !
Top
Sun, 2007-10-28 10:32
#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
Hi Luca
have a look into this thread:
http://www.planningplanet.com/forum/forum_post.asp?fid=1&Cat=8&Top=39078...
If you’ll have any difficulties, ask again and give the error message.
Good luck
Dieter
Top