P6 - how do i copy the project / back it up

D
DAVID SMITH 👤 Member for 22 years 2 months
A
armando moriles 👤 Member for 23 years 4 months

Dieter,



Thanks a lot...Now I have a backup file & sent copy to our IT...Thanks again.





Arman

D
Dieter Wambach 👤 Member for 19 years 4 months

Armando

Start --> Programs --> Microsoft SQL-Server 2005 --> SQL-Server Management Studio Express --> Log in --> select pmdb --> right mouse button --> all tasks --> back-up --> select the location of the backup-file --> run. You may mark write over existing... (I don’t remember the correct name). You’ll need the right to create a data-file within the selectect directory.



Or ask your IT staff



Good luck!



Dieter

A
armando moriles 👤 Member for 23 years 4 months

Arnold,



I have a problem locating the backup functionality which is actually this thread is all about. Can you give steps how to do the backup?



Also, can the backup database be copied, configure other pc using the backup database as the active database?



Many thanks...



Arman

A
Arnold Puy 👤 Member for 19 years 1 month

Hi Arman,



That’s right. It must be empty because you did not yet perform the backup. To make it not empty you must have to backup your database.



Regards.



Arnold

A
armando moriles 👤 Member for 23 years 4 months

Dieter,



Your right, I find it really important to backup the whole database.



Using P6, are you referring to the following?



c:\program files\MSSQL\primavera\MSSQL.1\MSSQL\Backup?



If it’s correct, then I have a problem because my Backup folder is empty...



Thanks...



Arman

D
Dieter Wambach 👤 Member for 19 years 4 months

David

The export copies one or more projects but you’ll have more know-how on your pc which might be destroyed by a crash or just by mis-usage.

1. Using export, don’t forget resources and roles. For import into a new database first import resources and roles then the projects. This doesn’t include EPS, preferences, ...

2. Primavera automatically includes MS SQL server studio express. Start it and use the backup-function. In the worst case this will be able to restore the complete database. The back-up you can easily learn by yourself, restore must be done by an IT staff.

A good start and good luck for planning!

Dieter

M
Mark Chapman 👤 Member for 20 years

The copying method isn’t ideal. If you want the project screen to contain a portfolio of projects and not just copies then this could be a problem.



There are at least 2 ways of getting round this and that’s creating a portfolio of projects (or sub-projects). This is a bit messy from memory.



Then you could use baselining as copying. This has the advantage that you can’t see this version on your project screen plus you can report on fields side by side. The down side it’s a little tricky to restore or review the majority of this project.



Finally you can use the method Tarek provide and then filter out the copied projects.



I hope this helps.

D
DAVID SMITH 👤 Member for 22 years 2 months

Tarek,



Thank you very much, worked a treat. Feel safe now!



Regards



Dave

T
Tarek Barham 👤 Member for 18 years 1 month

It is very simple,



to copy : go to project icon, select your project, open, right click copy, select the place to past it ( in the Enterprise structure) the make past action.



How to backup, just open the project, go to file menu, select export and follow the wizard.




Forum Sponsor

Top Posters

Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts