Project Content Recently Published

Please find below a recap of all content released by the Project User Assistance group during the past two months, happy reading/watching and keep deploying the EPM stack!

Office Online content:

• The PWA Role Guides These role guides present broad overviews of Office Project Web Access functionality from the perspective of the different roles your organization might have.
• Available fields This article lists all the fields available to users of Microsoft Office Project 2007.
• Set working times, vacations, and holidays for your project Creating resource and task calendars article now includes two videos to help with project scheduling.

Project Demo videos:

• Watch this: Use lag and lead time This demo shows how to use lag and lead time to create gaps and overlaps between tasks in a project.
• Watch this: Create a project This demo shows how to create a project, set project properties, and set file properties.
• Watch this: Set up a recurring task This demo shows how to create a task that repeats on a set schedule throughout a project.
• Watch this: Split a task This demo shows how to interrupt a task, creating a gap between two portions of the task. It also shows how to move the entire split task, adjust the length of the gap created by the split, and rejoin the split portions of the task to remove the gap.
• Watch this: Insert a task This demo shows how to insert a new task between two existing tasks in a project.
• Watch this: Group tasks or resources This demo shows how to group tasks, remove the grouping, and create a new resource group using multiple criteria.
• Watch this: Create a cross-project link This demo shows how to create task dependencies across separate Project 2007 files.
• Watch this: Link tasks in your project This demo shows how to create task dependencies within a single project, and how to adjust the link type for the dependency.

TechNet content

• Install Project Server 2007 in Windows Server 2008 (single-server installation) This article discusses the requirements and steps for installing Microsoft Office Project Server 2007 in a stand-alone Windows Server 2008 environment.
• Manage Active Directory synchronization in Project Server 2007 These articles describe how to configure and manage Active Directory synchronization of the Enterprise Resource Pool and Project Server security groups in Office Project Server 2007.
• Back up Project Server 2007 by using SQL Server tools Use this procedure to back up the databases associated with Office Project Server 2007.
• Migrate Project Server 2007 by using SQL Server tools Use this procedure to migrate the databases associated with Office Project Server 2007 from one computer to another.
• Restore Project Server 2007 by using SQL Server tools Use this procedure to restore the databases associated with Office Project Server 2007.
• Back up Project Server 2007 by using the Stsadm command-line tool Use these procedures to back up a server farm, Web application, database, site collection, site, or subsite by using the Stsadm command-line tool.
• Restore Project Server 2007 by using the Stsadm command-line tool Use these procedures to restore a server farm, Web application, database, site collection, site, or subsite by using the Stsadm command-line tool.
• Portfolio Analyzer Views Migration tool This article describes how to use the Portfolio Analyzer Views Migration tool. This tool allows Project Server administrators to bulk edit the Microsoft SQL Server Analysis Services settings in Data Analysis views.
• Project Server Data Populator tool This article describes how to use the Project Server Data Populator tool. This tool allows Project Server administrators to generate custom field, resource, project, task, and assignment data in bulk using the Project Server interface. Customers planning new or expanding existing Enterprise Project Management (EPM) implementations can use this tool to validate performance and storage-related metrics and determine hardware/architectural requirements.
• Project Workspace Site Relinker tool This article describes how to use the Project Workspace Site Relinker tool. This tool can be used to relink Project Workspace Sites that have become disconnected from Project Server 2007. These sites can become disconnected when a Project Server database is restored.
• Server Settings Backup/Restore tool This article describes how to use the Server Settings Backup/Restore tool. This tool allows Project Server administrators to back up server settings from a selected Project Server instance to an XML file. The tool can be run against another Project Server instance to which you can restore the server settings.
• View Effective Rights tool This article describes how to use the View Effective Rights tool. This tool can be used by Project Server administrators to troubleshoot issues regarding security settings and access control.

Comments

• Anonymous
  May 22, 2008
  Hi Christophe - I have been a avid reader of your blog for quite a while now, and firstly want to thank you for the fantastic content.  Its a great way for me to stay up to day with, for instance, newly released content like this. I was very excited to the Migration using SQL Tools and Restore using SQL Tools guides, as this is something that i had tried to achieve quite a couple of times on my own, but with now success. However, I think these guides are disgracefully inadequate as they do not go into nearly enough detail to be able to restore or move an installation using SQL db backups only.  It only lists steps for actually restoring the SQL databases which is great, but none of the detail I would expect to see is discussed: -In what state must the destination farm be?  Clean (no Web Apps), SSP Created, etc? -What should one do to link the Content DB and the SSP DB?  When I tried previously to simply attach the content db and restore the SSP database (using the Restore SSP in Central Administration) the PWA site that should have been in the Content DB was not accessible (giving an Unexpected Error Ocurred) and there were no PWA sites in the SSP Admin site. I have actually been going around customers and everyone else that its not possible to restore the configuration using SQL Tools only as there have been absolutely no documentation on this from Microsoft apart from the guides you have linked to.  The whole backup and restore story for Project Server 2007 is a miserable one, in my opinion and I have complained about this to all and sundry (through PSS, through our Account Manager, etc) but I am very disappointed to see that the situation does not improve. I am sorry for this essay on your post, but I wanted to point out that I don't think its feasible to post content like those guides in their current state. Thanks

• Anonymous
  May 31, 2008
  What you should be doing is leverage the SharePoint backup/restore feature to take care of the SSP, content db etc...

• Anonymous
  June 13, 2008
  Demo Videos Watch this: Use lag and lead time This demo shows how to use lag and lead time to create