Enterprise Database backup & restore
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
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
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.
Dont 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
thanks a lot .I am learning from you !
Hi Luca
have a look into this thread:
http://www.planningplanet.com/forum/forum_post.asp?fid=1&Cat=8&Top=3907…
If youll have any difficulties, ask again and give the error message.
Good luck
Dieter