Skip to content

Enterprise Database backup & restore

Luca BasileMember for 23 years 3 months
Created
4
3
0
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

4 replies

Oldest first
  1. 0
    Dieter Wambach ·
    Hi Luca
    have a look into this thread:
    http://www.planningplanet.com/forum/forum_post.asp?fid=1&Cat=8&Top=39078&page=2
    If you’ll have any difficulties, ask again and give the error message.
    Good luck
    Dieter
  2. 0
    Liu Yi ·
    thanks a lot .I am learning from you !
  3. 0
    Andrew Podolny ·
    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

  4. 0
    K D ·
    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

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?