Enterprise Database backup & restore

L
Luca Basile 👤 Member for 22 years 11 months
K
K D 👤 Member for 18 years 8 months

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

A
Andrew Podolny 👤 Member for 21 years 7 months

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


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