Project Server 2007: Why is my Archive DB so big?

In the August Cumulative Update for Project Server 2007 there was a fix for an issue with archiving projects (the Administrative Backup feature).  Some customers had noticed that the archive database was bigger than expected in relation to the retention policy they had set, and the size of their draft database.  In normal terms you…


Project Server 2007: Where did my Web Part go?

We had a recent customer incident where they could not drill in to projects from Project Center – they just saw a blank section of the page where the drill down should be on the ProjectDrillDown.aspx page.  The web part was gone.  Not sure what had happened – it could have been removed from the…


Project Server 2007: TechNet Document now live for using SQL Server 2008

****Update**** – The December 2008 release of the Feature pack for SQL Server 2005 at http://www.microsoft.com/downloads/details.aspx?FamilyID=536FD7D5-013F-49BC-9FC7-77DEDE4BB075&displaylang=en means that loading the Management Objects Collection from this release will avoid the workaround described in the TechNet article.  The writers have done a great job on revising the 2005 document to address 2008 – thanks Efren.  The document is here…


Now fixed: COMException on x64 platforms when automating Office clients via the Primary Interop Assembly (PIA)

I had the original posting early in the year, and having got another question on it I checked and the hotfix was released back in April to resolve this issue http://support.microsoft.com/kb/950136/en-us.  This hotfix is for the OS and not Project.  It also resolves the problem for other Office applications such as Word – which has…