for backing up your database in P5 (SQL), u logon to the SQL server and then to "Programs"-->"Microsoft SQL Server"-->"Enterprise Manager" then u choose "Databases" and then right click on your databse and "All Tasks"-->"Backup database" and then select where u want to put the file.
MSDE database file is in-use by the database server at all times. This means a file based backup utility will not backup the database correctly. You must use a tool specifically made to backup SQL Server/MSDE database.
The following soltuons are provided in the Primavera Knowledge base -- Solution ID: prim27893.
1. Use OSQL, which is an MSDE command line utility.
2. Use MSDE backup utility created for Contractor that will also work for Primavera 5.0. This can be downloaded from Primaveras knowledge base.
Spider Project is most functional and powerful professional project management software.
The first SP version was launched in 1993 and since then it has been constantly improved. Today is used in 34 countries though most Spider Project customers are in Russia. Spider Project offers numerous unique functional features and is the only PM software that optimizes resource, cost, and material constrained schedules and budgets for projects and portfolios.
The unique features of Spider Project include Quantity Based Scheduling, Conditional Scheduling, Skill Scheduling, Optimal Resource, Cost and Material Leveling, Resource Critical Path Calculation, Cash and Material Flows Calculation and Management, Trend Analysis, Advanced Risk Simulation and Analysis, Calculation of Success Probability Trends, Calculation and Management of required Project Time and Cost Buffers, Application of Corporate Norms, Management of many Parallel Budgets, Multiple WBS and many others.
Spider Project was and is used for management of many large scale programs in Russia, including $51bln construction program for 2014 Winter Olympic Games preparation.
The application areas where Spider Project is successfully used include Aerospace, Banking, Construction, Defense, Energy, Engineering, Infrastructure, Manufacturing, Metallurgy, Mining, Oil & Gas, Railways, Retail, Shipbuilding, Software Development, Telecommunications, Utilities, etc.
P6-Auditor - Display information from Primavera P6 audit tables in a user-friendly format
Unifier-Archiver - Extract and archive important documents and attachments from Primavera Unifier
Unifier-Loader - Load data into and out of Unifier via Excel
PCM-Loader - Import data into Primavera Contract Management with flexible and secure, template-driven Excel spreadsheets
PCM-Archiver - Extract and archive important documents and attachments from Primavera Contract Management
PCM-Unifier Migrator - Automatically transfer live and historical data from Primavera Contract Management to Primavera Unifier with ease
Create Radically Better Construction Schedules with ALICE Technologies
Use the power of AI to create construction schedules that reduce risk while cutting costs and build time. With ALICE, develop the ideal schedule during preconstruction -- or recover projects that are off schedule and over budget.
for backing up your database in P5 (SQL), u logon to the SQL server and then to "Programs"-->"Microsoft SQL Server"-->"Enterprise Manager" then u choose "Databases" and then right click on your databse and "All Tasks"-->"Backup database" and then select where u want to put the file.
Please see my previous post. Refer to Solution ID: prim27893 and there are two solutions posted there.
Or if you Google "Backup MSDE", there are others. Key point is you cannot simply copy files for SQL Server / MSDE database to properly back it up.
Its P5 and its a local database... please advise
MSDE database file is in-use by the database server at all times. This means a file based backup utility will not backup the database correctly. You must use a tool specifically made to backup SQL Server/MSDE database.
The following soltuons are provided in the Primavera Knowledge base -- Solution ID: prim27893.
1. Use OSQL, which is an MSDE command line utility.
2. Use MSDE backup utility created for Contractor that will also work for Primavera 5.0. This can be downloaded from Primaveras knowledge base.
Well this isnt my question, but I would like to know how to copy a MSDE database that resides on my laptop for backup purposes.
It contains a few layers of EPS nodes and several projects so exporting would be very tedious.
Thanks,
John
Are u using P3e or P5??
Is it a local database or a SQL/Oracle??
But if u want to transfer data base of only one Project, just export it.
Regards.