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
Member for20 years11 months
Submitted by Bill McMichael on Sun, 2006-05-21 09:30
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.
Member for
19 years 7 monthsRE: copy ing the Project database??
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 monthsRE: copy ing the Project database??
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
22 years 6 monthsRE: copy ing the Project database??
Its P5 and its a local database... please advise
Member for
20 years 10 monthsRE: copy ing the Project database??
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.
Member for
19 years 5 monthsRE: copy ing the Project database??
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
Member for
20 yearsRE: copy ing the Project database??
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.