copy ing the Project database??

Member for

19 years 7 months

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.

Member for

20 years 10 months

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.

Member for

20 years 10 months

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 Primavera’s knowledge base.

Member for

19 years 5 months

Well this isn’t 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

Member for

20 years

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.