copy ing the Project database??
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
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.